-
Nested IF AND/OR Formulas
I am trying to compare Date and Health columns and derive if it requires an update or not. Conditions are If the date is in the past and the Health is Blue = Update Not Required If the date is in the past and Health is either Yellow, Green, Red = Update Required If the date is in the future and Health is either Yellow,…
-
Auto generated emails taking 30 mins to get back to user
Afternoon, It appears that the automatically generated emails in smartsheet are taking upto 30 minutes to come back to the user. Is there a system issue? Thanks, Karl
-
IF Statement
I am trying to have a flag cell (Tasks Past Due Alert) trigger when other flags are raced in the row. If there is any of the flag status cells with a flag, I want the Task Past Due Alert to raise a flag. No luck so far with the formula. Any suggestions?
-
Is there a way to add formatting or hyperlinks into a form description?
Is there a way to add formatting or hyperlinks into a form description?
-
Personal logo in Forms
Does anyone know why sometimes when you (I) create a new form, the label icon is "Smart Sheet" but sometimes it is my company logo and colors. I set up so that my company logo and colors are the default, but 99% of the time when I create a grid and turn it into a Form, it has the "Smart Sheet' logo and colors. I cant…
-
Click through dashboard report widget to highlighted row
Hi, In a report, the clickable link in the Sheet Name column takes you to the source sheet and highlights the row that was clicked on. In a report widget, within a dashboard, is there a way to make the clickable link in the Sheet Name column also highlight the row in the source sheet when opened as this does not occur…
-
Columns Widths when Printing Smart Sheet
I have come back to SS after a year or so and am enjoying using except, my main bugbear from last time has not be fixed! The width of the text when printed (or pd fing) does not reflect what's in my SS model. Lots of additional space in cols when printing, Very frustrating, please fix this SS. Richard
-
Combining multiple views of a project plan in one
In our previous solution, we had five project plans for users to choose from. This caused reporting issues as our milestones did not align between project plans. Has anyone combined project plans into one template and allowed the user to see the appropriate tasks for their chosen project plan by perhaps a filter? Example,…
-
Date Range Conflict - Vacation Request Sheet
Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me. Form requests will populate new rows of all time off…
-
Search Window Widget for Dashboard
We have a sheet that contains a list of applications, application manufacturers and will contain the link to where software packages for each package are stored in another program. We're looking for a way to provide a keyword search window where the user could type in the application name or manufacturer and view search…