-
Save as New
I love how the Save as New now has the ability to include Notifications & Sharing options to be saved; however, why are reminders not included? With dozens of sheets that have notifications and reminders that I roll forward each month, this new feature is still not useful/complete because reminders aren't captured.
-
Tempo Account Field Not Updating in Smartsheet
We are working with a JIRA instance that is connected to Smartsheet and writes data both ways. The JIRA instance utilizes the Tempo Timesheets add-on. One of the fields in a Smartsheet contains a column that is mapped to the Tempo Account field which is a locked, single select custom field in JIRA created from Tempo. This…
-
Sum of each Dropdown Option Selected Formula Help
Any Suggestions on the simplest way to formulate this? * Dropdown Column - "Part Status" * Dropdown Options - "Delayed" "Not Started" "In Progress" "Warehouse" "Shipped" I want to show a total sheet sum for EACH Dropdown Option shown. Part Status is only selected on the Parent Rows. Rows 4-287 with 30 Parent Rows. Thanks…
-
Remove print range lines from Gant view
I have a sheet which uses a gant view. After I had exported it, I now see print range lines running vertically on the sheet. Is there any way to remove these? I have found that the export functions don't meet my needs and I would rather take a screen shot of the gant, but the lines don't look good. Thank you very much
-
Reminder Notifications: translate from templates to new sheets?
Loving Smartsheet so far, and excited about finally having a truly custom system together for tracking project status for our clients, based on our unique parameters and not something superimposed! I've created a template that is working well, but would love to see reminder notifications translate from the template to…
-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Show Value Sum of total Parent Rows checked.
I've researched this and cant find a solution. How can I set up a CountIf formula for ONLY if Parent Rows are checked in an entire sheet? I can do this for the children rows but cant figure out how to do it only for Parent rows. Also, Can I place this formula on the checkbox column (at the very top for a total) and show a…
