-
Roll up features vs Snapshot features
New to Smartsheet, and getting acquainted with workspace someone else built. Why doesn't the "roll up" sheet have something that was entered on the corresponding form and Snapshot Report does?
-
Alternative API endpoint for listing workspace templates after Feb 2026 deprecation?
With the announcement of the deprecation of "/workspaces/{workspaceId}" and the deprecation of the template listing endpoint (https://developers.smartsheet.com/api/smartsheet/changelog#template-listing-endpoints) There does not seem to be a way to retrieve a list of templates for a given workspace. Our app relies on these…
-
Sheet Button on Left of Sheet - Error Message
Could somone tell me what button this error message is referring to? I have an Enterprise plan and do not see anything like a "Sheet" button.
-
Based on frequency selected change the formula for the created date.
I feel like this should be super simple but I am just not getting it right. Based on Frequency: Daily, weekly, monthly I want to change the next due date This will be calulated from Created column and +1, 7, 30 etc added. It works single instance =IF(Frequency@row = "Daily", Created@row + 1) but as soon as I try to write…
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if the…
-
Able to send only one row at a time?
Hello. I need to send a sheet to multiple different people and I want them to only be able to interact with their specific row. Is this possible? eg: 10 rows(person A, comment) I want Row 1 to go to person A and for them to only see their row and only comment in their specific section, Row 2 → person B, etc, etc. Any help…
-
Printing comments under relevant tasks
I've got a sheet set up with multiple tasks assigned to different people. When printing the sheet the comments are all listed at the bottom of the sheet rather than under the relevant tasks. Is there a setting that allows the comments to be printed under each task ?
-
Collect cross sheet formula help
I want to pull through the task name in one sheet where the check box at row is checked into another target sheet. This is what I though the formula would be but I get #UNPARSEABLE as the error. =INDEX(COLLECT({Task name}, {Stage check box}@row , 1)) Um, help please?
-
Linking another Sheet
Hi All, I am having some challenges which I was hoping someone might be able to help me with… There is an existing Smartsheet that a project team uses to display new product introductions. As this sheet is updated in real time and I am not in that team, I can't add fields that I want to track into that sheet; however, some…
-
Adding cells with IFERROR blanks
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…