-
Duplicate Notifications From Automations
We are getting duplicate notifications from our automations. These automations have been in place for over three years and have never done this before. There have been no changes made to any of them. This is happening on a variety of sheets and a variety of automations. It started sometime about mid August. Is anyone else…
-
Assigning matching but random form re-submissions to same user for review?
I have a sheet designed to assign submitted form information for review on a rotating basis between 3 people. That’s all working fine. The issue I’m having is that if a form is resubmitted for secondary review, I need it to assign to the original person and not fall into the rotation. So find any duplicates in a column…
-
Assign same person to review re-submitted form tasks?
I have a sheet designed to assign submitted form information for review on a rotating basis between 3 people. That’s all working fine. The issue I’m having is that if a form is resubmitted for secondary review, I need it to assign to the original person and not fall into the rotation. So find any duplicates in a column…
-
Project Health Formula
Hi good afternoon, Community Members, I need some help please. I have an issue with my Health Formula. Here are some of the concerns: I have Red tasks, but they do not affect the timeline. Actual completion is ahead of Expected %, but Health is Red. An activity is Yellow when it should be Green. One delayed task makes the…
-
Can SYS_CELLIMAGE() / in-cell image thumbnails be populated programmatically via the Smartsheet API?
We are trying to automate the population of image thumbnails into a Smartsheet sheet containing approximately 1,885 asset records. Current setup: - Each row contains a unique Asset ID (e.g. ID-01897) - We have a matching image file for every Asset ID (ID-01897.jpg, ID-01896.jpg, etc.) - Images already exist locally and can…
-
How to add a time value to a cell when a value is entered in Start time column
Hi, I have a Workbook. It is a tracker. I need to add a time value in hh:mm in a start time column, this is triggered by another column entry. Then I need the the time value in the stop time column, this is triggered by a value in another column. Then I need the total hours hh:mm stop time - start time. I can do it in…
-
Feature Request - Close "Used in Formula on:" Popout
ASK: Add a "X" or small close button in top right of "Used in Formula" popout to temp disable it from displaying. EXAMPLE: Cells which have values used in other formulas will display a popout when selected. The popout that appears is dynamic it will often float overtop of a drop down list covering up the of the first…
-
Formulas
Hello, Can somebody help me to know why this formula is not working when when I make it a column formula instead of a cell formula. It becomes Invalid Ref. SUMIFS({03. Entrée Plage 1}; {03. Entrée Plage 2}; [Mois]@row; {03. Entrée Plage 3}; [Foreuse]@row; {03. Entrée Plage 4}; "Maintenance"). The formula is calculating the…
-
Recurring Date Formula in Smartsheet – 30, 45, Quarterly, etc.
Hello All, I created a tracker in Smartsheet and automated several features within it. One of those features automatically generates future reporting dates based on the required reporting frequency, such as every 30 days, every 45 days, quarterly, etc. The issue I’m running into is that the dates start to drift by a few…
-
Date/Time maths formula
Hey, I have a sheet tracking events with start date, start time, end date, end time (amongst other information) using conditional formatting I want events in the past (including that day) to grey out. In the Sheet Summary I have a "Last Modified" field using =MAX(Modified:Modified) + "" I have a helper column that joins…