Smartsheet api indent However, I need to report out this information at the store level. Is that possible? You could use the API to solve this. Project 1, Project 2, etc. The keys are working just fine (able to CTRL + C/V, and the [ and ] keys all work individually) but it does not allow her to indent rows using the keyboard shortcut. I would like to indent that row if the Activity ID is not First, a few things to understand about specifying row location: By default, new rows are added to the bottom of the sheet -- so it's not necessary to specify the toBottom property if you want new rows to be added to the bottom Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else. I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. Webhook Ownership & Access Welcome to the Smartsheet Forum Archives The posts in this forum are no longer monitored for accuracy and their content may no longer be current. Workspaces. He's importing data using data shuttle but the csv file tracks levels in a column called Level. Workflow Notifications (Alerts) The Manufacturing department in my company created If you have multiple levels of Parent rows (different indent levels) and you only want the top level, smartsheet has a function called ancestors. In order to create a hierarchy, data needs to exist in boththe parent and child rows. The indentation issue could be caused by a blank cell in your primary column. My main challenge is ensuring that these tasks are automatically associated with their respective main projects and indented correctly I'm struggling with the automation part. I tried to insert a new formula field into my spreadsheet using this function and it worked perfectly. Hi Smartsheet, Please make it simpler to populate columns in the Alert Someone automation. Maybe with a slightly colored background for the ancestor and/or (See: Hierarchy: Indent or Outdent Rows). It wont let me reapply the indent/outdent option either. What do i do? The deeper the level of indent in the WBS, the more detailed. A User in Smartsheet must have a primary email address associated with their user account (User. Smartsheet . , Item Description, Quantity, Unit Price" columns under the Primary column " Requested By. The documentation for each operation that supports multipart uploads specifies the number and names of parts that are expected for the operation. The row above it will become the parent row. For example, if the Project Plan / WBS Hierarchy column has a value of Milestone, indent the Activity Name cell two spaces. That To protect against infinite loops like the one outlined above, Smartsheet introduced support for a new header that an API client can include with any API request that adds, updates, or deletes data in Smartsheet. Webhook Ownership & Access Interactive Dashboard without Dynamic View? Hi, I have a sheet where the user enters a code which then brings back metadata from other sheets. I propose, when creating a form and having the primary column selected on the left, that an option be available on the right for "Default Indentation". The Unique ID with the lowest suffix should be the parent row and subsequent ones should be children. Smartsheet(access_token) # Set the sheet ID sheet_id = "Your Sheet ID" # Retrieve the sheet with attachments sheet In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for When exporting a smartsheet to google sheets, the indent formatting doesn't pass over to the google sheet. If it's all row data, I'd put a support ticket into SmartSheet. There may be a limit but it likely isn't anything you'll ever need to use. You can delete, update, or retrieve various automation settings through the API. Summary field with formula by API. File parts must have the part name "file", and documentation for operations which allow for JSON object parts specify the required part Concatenate formula to combine Date and Time into unique code. I am trying to count the number of times "N/A" is included in a single row. Ask questions Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. I have the max salary part sorted - =MAX(COLLECT(Salary:Salary, [Job Title]:[Job Title], "Senior Quantity I'm trying to write a formula that will indent the items in my Activity Name column based on the value in my Project Plan / WBS Hierarchy column. indent nor row. To indent row 3, you need data in the primary column of row 2, etc. Developers & API; Help ©2025 Copy and Pasting Multiple Rows from Excel into One Multi Dropdown Select Cell in Smartsheet. You cannot create new Follow these five steps, which we’ve detailed below: 1. I could possibly: create the parent row > add_rows() > get_sheet() > find the row id in sheet > create the child row > add_rows() but I'm losing the benefits of bulk Hello, I have report that is created from a project plan using a helper column to bring in parent level tasks. Alternatively, if you just want to erase all hierarchy, you could insert a Extract data from a Program level report. I have a column named "Project Plan / WBS Hierarchy" and based on the type of task in that column, I want to indent my "Activity Name" column. Same for indent. In I’ve done similar things by creating helper columns using formulas that display values that I can then use in a report to group by, which duplicates the parent child look I think you’re going for. Use the Smartsheet API to create and manage webhooks. The last part in the request must be followed by the boundary string,. js. Thanks. parent_id seem possible to set on new rows (since the fresh rows don't have an id yet). There's no double indent. I am directly writing tasks into the Task Name column for a new, shared project. Not sure what's causing this issue. Webhook Ownership & Access SmartSheet will automatically roll-up children dates to parent rows. The column is named "Contract First Day" and see the image how it populates multiple dates. Is there any way to see an audit trail of emails sent from Smartsheet? Emails sent via an automated workflow or from a project manager sending the email using the "File >Send as Attachment" or "File> Email shared users". Webhook Ownership & Access Welcome to the OpenAPI reference documentation for the Smartsheet API! IMPORTANT: The Smartsheet API is restricted to users on Business and Enterprise plans; The Developer Agreement governs the use of the Smartsheet API and Smartsheet software development kits (SDKs) QUICKLINKS. I tried couple of options, but I was getting exception. operations which allow for JSON object parts specify the required part Indent and outdent. Does smartsheet have a script or solution to address this? Hi @Travis Myers Hope you are fine, @Tom Zylstra had created a very good solution for Work Breakdown structure, please check his post i think you will find a great help for your case: Work Breakdown Structure (WBS) - Smartsheet events Your hub for Smartsheet events, webinars, Q&As, and user groups. It looks like your Auto number column contains 0's leading up to the actual number. One feature I really feel the need of is the possibility to have graphical display of the indent level of the rows. Third Party 1; I can do that, but it's the indentation that I would really like Indent a row. Craig Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. Can some one help me with this? You need to handle the rate limit for a sheet like yours with 5,000 rows (e. Maybe a dropdown column with a specific data list. 3. Also, there are several premium apps that smartsheet offers The official Smartsheet developer portal, blog, and developer resources. It would be very helpful to have a way that the indent/outdent feature is made available on Reports and Dashboards. To specify a location for new or updated rows other than the defaults, use the table below for reference. I know it will go at least 16 levels. Any advice on how to proceed would be great. Webhook Ownership & Access Hi all, Is it possible to indent rows in Dynamic View? Sending Alert Email based on Contact Column without sharing sheet. In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for Hello SS Developers! I am both a formula and API-deficient SS user. Workstream 0 (no indenting) Subfunction 1 indent space. However it becomes very time consuming when each indentation is a separate API call. Report Attachments For details about working with a report's attachments, see Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. 2, etc. email) and may optionally have one or more alternate email addresses associated with their account (User. Workflow Notifications (Alerts) The Manufacturing department in my company created To protect against infinite loops like the one outlined above, Smartsheet introduced support for a new header that an API client can include with any API request that adds, updates, or deletes data in Smartsheet. Similar to a folder, a workspace is a place where you can store dashboards, reports, sheets, and templates to keep them organized. I used Smartsheet report tool to merge two sheets with common column names. Webhook Ownership & Access Hi, I have a column which has multiple dates in each field as its populated from an outside software which integrates to smartsheet. I keep hitting dead ends or examples for everything besides PDFs. Learn more; Project management templates; Smartsheet dashboard gallery; Getting started with the Smartsheet API Automation is a catch-all term for approvals, notifications, and update requests. I believe my question should be directed toward the API/Developer community, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy". Smartsheet(YOUR_API_TOKEN) workspaces = smartSheetClient. There you’ll find Indent a row. For example, "Workstream" items should not be indented at all, Subfunction should have 1 indent space, etc. However I think, based on your initial description, manually copying/pasting the task where it should be is actually the best way to proceed to ensure that Hi @Jim Thiesse. Workflow Notifications (Alerts) The Manufacturing department in my company created Hi @Angela Logie. Iterate over rows in smartsheet and indent based on value in column using node. , by adding a delay after every 300 API calls) import smartsheet import requests access_token = "Your access token" smartsheet_client = smartsheet. As SMARTSHEET EXPERT CONSULTANT & PARTNER. e. Workaround is helper columns and conditional formatting but far from ideal I would really love to see the indent levels of tasks in report based on a project plan. Use Ctrl and ] at the same time to make a row a child (or right click and select indent) and Ctrl and [ at the same time to reverse that (or right click and select outdent). Hi all - i'm looking to move a row from a sheet into another sheet and have it automatically indent under a grouping. I am new to smartsheet and am trying to indent as follows:-parent level -child level 1 +1 +2 -child level 2 I cant seem to get it to allow me to indent the child level 2. Select a cell in the first row you’d like to indent, and then select the Indent Brandfolder Image button on the toolbar. 0 Can you give a bit more information about how to use the API to indent? I am wanting to indent rows that I am importing via a call to the API through CozyRoc. " to emulate the indent (dot and space to indent because smartsheet truncates all combinations of multiples spaces into single space even when you use char(32) ) =IF Hello, I have a requisition form and want to indent the "Part No. Andrée Starå | Workflow Consultant / CEO @ WORK BOLD. What would be REALLY nice is some kind of automatic sorting/indentation based on common fields in a form entry where we wouldn't have to do anything after the initial setup. And when you update a row, the default behavior is to keep the row where it is. 1. import smartsheet smartSheetClient = smartsheet. The list of system users is I don't think there's a way to automate it as-is, but you can certainly speed up the process by using the keyboard shortcut ctrl+] to indent and ctrl+[ to remove a hierarchy. com | E:andree@workbold. File parts must have the part name "file", and documentation for operations which allow for JSON object parts specify the required part If the button is grayed out, that means you're outdented all the way. The following operations must be performed using an user's primary email address: * Add Group Members * Add User * Create Update Request * Share I am trying to create a smartsheet using Java API that fills data in parent/child task format. Hello everyone, I have a function that I run via API that helps me replicate improvements across all the spreadsheets for projects I work on. followed by two hyphens. Else, the change which triggered the callback was not caused by the subscriber itself, and if the subscriber is going to subsequently react to the callback by making a change in Smartsheet (via API request), the API client should append a comma and its own identifier to the original attribute value, and pass that value through using the Based on the field "Parent Process", it would indent underneath that process field. Developers & API; Help Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else. I would like to track the email that was sent, the date and to who it was sent. Every time the report refresh, the indent gets removed off. The last part in the request must be followed by the boundary string, followed by two hyphens. SMARTSHEET EXPERT CONSULTANT & PARTNER. operations which allow for JSON object parts specify the required part Hi, I'm new to Smartsheet - I have created a Task list and want to create parent and child rows in a task list, but the indent/outdent buttons are shaded out and the shortcuts (Ctrl ] ) don't do anything. . Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. When you add a row, the default behavior is for Smartsheet to put the new row at the bottom of the sheet. Upon reviewing your post, I recommend visiting the link here. If your only reason to indent is to use formulas with CHILDREN() or PARENT(), then careful redesign of the sheet may remove this liability. I want to share sheets with my whole operation (75+ people), but having to individually In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". Integration (Optional) Integerate your apps with Smartsheet via OAuth Getting Started guide, API Reference, and code snippets Documentation. js Quickstart Guide: How to return the rows array returned from API into a variable. Once you indent the indent button gets grayed out. To indent row 2 you MUST have data in the primary column of row 1. What is he best way to extract the reported data into a grid and keep the grid current. The documentation for each operation that supports multipart uploads. If the Indent button is unavailable, you may be trying to indent a +1 for indentation options when using forms to populate tables. Is there a quick way to identify or List all the Smartsheet Links? Hi There I have a worksheet that I have inherited, and need a way to identify all Links from a cell in other sheets. I want to share sheets with my whole operation (75+ people), but having to individually Hello @Jason R Dong. In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". How to get column title for each row entry. Hello, I am new to using Smartsheet for project planning. Webhook Management. It would be nice to have some more obvious way to display indented rows with the ancestral grouping other than the slightly indented text. Sub-Task 1. I need to read the value in level and indent I am trying to create a smartsheet that automatically indents child rows from a form submission. Bob Indent rows with Smartsheet API with Java. All rows that are indented become outdented (left justified). A workspace offers more functionality than a folder because you can set up sharing permissions and branding (a logo and a color scheme) at the workspace-level and a workspace can contain folders so that you can keep things within it organized. Automatically indent . Indent pretty JSON in Google Sheet Apps Script. Hello everyone, I have a function that I run Audit trail for sent emails from Smartsheet. I've recently set up a Data Shuttle so we can transition from manually editing the report in Excel to a more fully automated report in Smartsheet. Kickstart your code with sample apps and complex snippets See Samples. We would still like to show the data in smartsheet though, as it's easier to share, plus we're paying a whole lot of money for the Enterprise plan. In the picture, When the child record Celia is added from a different sheet, via automation, it lands at the bottom of the sheet. I have a formula that can do numbering such as: Task 1. Good Morning fellow smartsheeters!!! Is it possible to copy and paste multiple rows from excel into one cell in smartsheet when that cell is apart of multi dropdown select? For my use case, Each Market as an offer associated with it in column D. Welcome to the Smartsheet Forum Archives However, when I click the indent on the child rows, the cursor on the parent row is missing. The current solution is still to expand the rows and copy the full extend of the hierarchy that you want duplicated. File parts must have the part name "file", and documentation for operations which allow for JSON object parts specify the required part I am trying to write a simple program in Java using the Smartsheet API that goes through a fairly large sheet, and indents certain rows. File parts must have the part name "file", and documentation for. The workaround is to manually edit the google sheet by entering spaces on the lines that were not indented. Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else. You can upload a file by performing either a simple upload or a multipart upload. This is not a standard Zapier action, but it can be done. If there's a discussion here that interests you and you'd like to find (or create) a Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. If the Indent button is unavailable, you may be trying to indent a blank row. There's some pretty well-defined notes regarding parent and location for the specifics you are encountering such as: Indentation would be a great improvement on reports, but at the very least I would like the gannt bar for parent tasks to appear as it does on the original sheet. Leading 0's will translate the number into a text value (to keep the 0 showing) so it can't be evaluated with the RANKEQ Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. You should be able to indent rows and make them Child Rows even with just Editor permissions. Task 3 ident How can I use API to attach a local PDF to a Smartsheet row through Kofax/Tungsten? I've been trying to figure out how to configure Kofax's Call REST Web Service step so I can use an API to attach local PDFs to specific rows of a Smartsheet. com | P: +46 (0) - 72 - 510 99 35 How to indent several Rows and can we indent at different rows in the same sheet? Thanks. get_workspace( workspace_id=YOUR_WORKSPACE_ID, load_all=True ) indent=4)) This provides you a Python Dict of the Workspace's content. Column({ 'id': column_id , Hi @Briz0wns. The API will you to indent/outdent rows. (see the in process indent on the attached) It is making child The following section describes the specific event types and payloads returned from the Smartsheet Events API. They are considering Smartsheet for Report updates and distribution, and asked if Smartsheet can directly pull in the LIVE STOCK data (as excel does). Both sheets have their own indent function. So, I tried another option, where I created the sheet and then re-read the sheet and tried to indent the rows using following code - Yes, just go to the row you want to indent and indent (Ctrl+K or the button) You can't indent any row more than one level below its parent, but it can be indented several levels deep. alternateEmails). Like the Smartsheet app, the Smartsheet API allows uploading files to sheets, rows, and comments. This has happened to me a number of times and seems to happen when the combination of rows and columns is large but less than the 500,000 cell limit. Community. Hi - I am new to Smartsheet and trying to figure out how to move my folders and place them in the order of the workflow I want. Today all tasks are shown left-aligned. ) def delete_due_on return # Step 2: Remove the formula (if any) column_update = smartsheet. Explore developer resources. Is there a way to have a template automatically indent in a particular column which only happens when triggered by automation. The Smartsheet Developer Portal is the “home base” for all developer resources. Keep in mind that rows need to have data in them in order to be indented (you cannot make a blank row a child row). Getting started with the Smartsheet API; Watch a demo; Start a trial; To hide a row in Smartsheet, indent the row using the Indent button at the top of the sheet. To protect against infinite loops like the one outlined above, Smartsheet introduced support for a new header that an API client can include with any API request that adds, updates, or deletes I need to setup an auto indent for a client. I think the only option at the moment is the Smartsheet API. I want to automatically indent based on the Unique ID as shown in the below example. W: www. Thus, it is getting tedious to manually write "Task 1. Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 1" for the child task of the parent Task 1 because the tasks can be edited/moved. One of my prospective customers currently uses excel (built-in STOCK data type & function) to pull in live Securities Price Data from the stock market (NSE). See all events; ENGAGE Smartsheet ENGAGE brings together our global customers, experts, and partners to share their experiences, ideas, and best practices. com | P: +46 (0) - 72 - 510 99 35. Is there any way to get smart sheet rows based on column value. Concatenate formula to combine Date and Time into unique code. Then, hide the row using the - button that appears in the parent row above it, The last part in the request must be followed by the boundary string, followed by two hyphens. It would be super helpful (significantly reduce API calls and transactions if we could update multiple row locations when we update rows. Webhook Ownership & Access Hi @Rashada Alexander. workbold. Is there a formula i could use that would tell met the level of indent? The reason is to set up common schedule templates that will consolidate multiple projects into reports with Gantt bars to produce a Gantt of Gantts (program view) Thank you. g. 1, 1. I've never seen all row data disappear, only date data. Hi there, If you look at the attached image you can see the issue I'm having - the issue is that the line items colored GREEN should appear directly under the gray "Universal masthead design / Tone / Messaging" bar since Is there any way to indent specific rows in the primary column that meet a specific condition, like through conditional formatting? For example, WBS ID is the Primary Column. See: Copy and Paste Cells, Rows, Formulas, Hierarchy, and Hyperlinks An alternative could be to use the Copy Row feature to copy the Parent row to another sheet, which will bring all the child rows with it. I would be interested to see this as a feature though, as I Automation is a catch-all term for approvals, notifications, and update requests. Like a sheet, a report is comprised of columns, rows, and cells, and may optionally contain attachments and discussions. ) for each of the tasks under the Project. specifies the number and names of parts that are expected for the operation. This Smartsheet API; Is that an option? I hope that helps! Be safe, and have a fantastic week! Best, Andrée Starå | Workflow Consultant / CEO @ WORK BOLD. I then have a formula in hte "Fill in last day" column which extracts the last date in the The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. Smartsheet API; Is that an option? I hope that helps! Be safe and have a smartsheet expert consultant & partner Andrée Starå | Workflow Consultant / CEO @ WORK BOLD W: www. I am using Data Shuttle to bring data from an external source into my SmartSheet. Thus, if you indent and the row below doesn't yet have dates, the cell clears to match the children roll-up data below. I would like to have this field on a dashboard so the end user doesn't have to navigate to the sheet but enters it in the dashboard (which is the field in the sheet itself). @Andrée Starå no problem, I must do some homework on the API! The second to use ". com | E: andree@workbold. I would prefer not to use a WBS system where I am numbering all the rows such as 1, 1. Right now, there is a main "parent" form, then a linked "child" form that creates a Select a cell in the first row you’d like to indent, and then select the Indent Brandfolder Image button on the toolbar. Disabled Reasons for Automation Rules Reason | Description | -----|-----| **APPROVAL_COLUMN_MISSING** | This rule's approval status column has been The last part in the request must be followed by the boundary string, followed by two hyphens. You can only indent once as once it becomes a child it's a child. menu. However, I need some rows to be children of other rows, and neither row. When I add the report onto my dashboard the last entry in the report is indented, I don't understand why this is and how to fix it. Sending indented rows is helpful. @rachel. Milestone 2 indent spaces. You cannot create new automation rules programmatically. operations which allow for JSON object parts specify the required part A report is a filtered view of the data from one or more sheets. When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. Since I'm working with big files of data, sometimes I don't have the father row and the children ones (which have been indented) on screen, but I have to scroll the sheet. Here's how it works:An API client includes the Smartsheet-Change-Agent header in any API request that adds, updates, or deletes data When adding new rows to a sheet, with a Parent ID number, the child line should indent under the Parent line. Google Sheets Node. 0. To make your blue rows the parents of the rows below you need to: Outdent row 40 - There might be 6 different store numbers listed in a single cell. You can use this to designate a specific level of hierarchy to collect on your report. @Andrée Starå the ability to automatically indent a new row would be a great feature. Base URL: Hi @Jona_g28. Webhook Ownership & Access Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. Formula - use % complete to determine whether in progress Developers & API; Help ©2025 Because the callbacks are "skinny", make one or more requests to the Smartsheet API to retrieve the actual data associated with the change. Then you can Copy that same Counting occurrences of a string in a row. There are a few ways you can do this. With Event Reporting, you can programmatically retrieve events that are occurring in your Smartsheet organization account. Especially if you are One way is to copy and past the dates into another document, indent the tasks needed, and paste them back in, but that seems like a less-than optimal choice. I would be interested to see this as a feature though, as I ctrl-] and ctrl-[ do nothing for me in my Gantt views. A simple upload allows you to add a single file attachment to the specified object. models. Since each "Project" is an indent level of 2, I've been trying to create a formula that would return the Project name by looking for the closest last level 2 at or above the search row. Webhook Ownership & Access Is there a formula or existing function to indent only blank cells in a column? Thanks for any information! Want to practice working with formulas directly in Smartsheet? Check out the Formula Handbook template! Trending in Formulas and Functions . Here's how it works:An API client includes the Smartsheet-Change-Agent header in any API request that adds, updates, or deletes data The last part in the request must be followed by the boundary string, followed by two hyphens. I have used Zapier to effectively move rows within a sheet. A report is comprised of columns, rows, and cells, and may optionally contain attachments and discussions. . The documentation for each operation that supports multipart uploads specifies the number For example, the Smartsheet Events API shows 5629504736520068 as the userId when an anonymous user accesses a sheet that is published for anyone. The solution for "Workflow Execute: deleteAllRows failed, cannot proceed adding new rows" is to delete the rows on your smartsheet prior to attaching the file that triggers your data shuttle. I hope you're well and safe! This might help! (It won't indent, but separate the different submissions) I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first. Note: while the current list Smartsheet summary formula. Has anyone tried to create a trivia game using Smartsheet? Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate Is there Task indent fucntionality in the Android App - if do please advise? Seems to be restricted functionality relative to the Ipad App - hovering over app gives less options on Android v Ipad ALSO certain colums appear locked such as End date and Predecessors why? I'm looking for a formula that will return the Project Name (i. I am able to create a indent on this report, but not able to save it. g If all you want is the structure of the sheet (the columns) and not the rows, just delete all the rows. A place to discuss and share knowledge about the Smartsheet collaboration tool. Samples. Would be nice I don't think there's a way to automate it as-is, but you can certainly speed up the process by using the keyboard shortcut ctrl+] to indent and ctrl+[ to remove a hierarchy. With a rising count of tasks, subtasks and subtasks of a subtasks (and so on) it becomes confusing and unreadable. I thought I could just add blank lines beneath the "main" bug/issue and then indent the line, but I am attempting to delete the column using python and the API. Here is some code similar to what I'm using. (note: Indentation is correct on actual code, copying messed it up. It will make it easier The last part in the request must be followed by the boundary string,. I am working on a project tracker in Smartsheet and need help setting up a form that allows users to add tasks under specific projects. Examples of events are create, update, load, and delete of sheets, reports, dashboards, attachments, and users. One way would be to collapse all rows, then open up each hierarchy, select all its child rows in one go, then outdent using the toolbar (). ". I have over a years worth of indented drop down list worth of info and randomly one day all of the indent buttons disappeared and i cannot open any of the indented drop down lists unless i randomly search something in that list. 2. developers. Hi All I am trying to create a smartsheet formula for the Summary field that will return the maximum someone in a Senior Quantity Surveyor role is being paid currently in the company, plus the name of the person. See Webhooks API Reference for details about the related API operations. I want to share sheets with my whole operation (75+ people), but having to individually Finally, you could look into using the Smartsheet API to copy rows. We just ran a survey in Smartsheet using forms, and its going through the next 2 weeks, i want to gather how many we have received from our survey document and display it on my metrics, to then display it on a dashboard. If the Indent button is unavailable, you may be trying to indent a As I wrote in the stack overflow, I'm now hoping to find a way to upload a whole xlsx file as one, as the xlsx Python API lets me generate these sheets much quicker with all the indentation I need. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to exclude. I've tested on a sheet where I have Editor permissions, and I can copy the row information from locked row, paste it in another row, and then indent this new row (as long as there's information in the row above where I pasted). I have a report with the Report Scope set to "Programs". It is not necessary to use a location-specifier attribute if you want the default behavior. In fact, when you "Save as New" to create the new project you can NOT create any rows at all but still get the identical column structure.
ghkwy ejn ijzwv qmpaf xksgyl yfgiw dvaimxqj kkwad nmgtmjuom qwys wku oacps iheq udho ugkxe