-
Daily Notification
Hi All, Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date, Red is overdue). What I would like to do is once the dot turns Red, to have a…
-
Add Custom Image For Trend Widget
Hi, I am able to setup a widget that is link to a direction symbol (up, down, neutral) for my data. What i want to do is have a customer image for each (up,down,neutral). Is it possible to have a conditional statement that will present the relevant image to the widget? I have tried within a sheet, by adding the image to a…
-
Multiple SUMIF within a single cell?
Hello, I'm trying to build a template which would allow vendors to log hours against a project and automatically calculate a cost for each task. This calculation looks at the name of the individual reporting hours along with the listing of approved hours for the task then multiplies it against that individual's hourly rate…
-
VLOOKUP Gone?
Yesterday I was using VLOOKUP to help me reference data from another sheet and today the equation is completely missing and now all I can find is LOOKUP which doesn't let me reference other sheets? Am I missing something? Bring back VLOOKUP to help me reference other cells.
-
Looking to set Notifications/Reminders beyond the default options
Hello - I'm a bit new to Smartsheet but loving it so far. I have a few columns with dates that I would like email notifications or reminders set up when the following conditions occur: 1 year anniversary from date in cell 5 years, 9 months after date in cell, IF another cell has a certain value 9 years, 9 months after date…
-
Tire Maintenance - Form / Spreadsheet Assistance
Hello All, Today is my first day (YAY!). I'm digging Smartsheet thus far, although, I'm looking for suggestions. I've been tasked with creating a Tire Maintenance Program. So far I've put the basic asset information (Year, Make, Model, VIN, Tire Size(s). Screen shot will help make sense of this. The key part is trying to…
-
Revising duration so it doesn't count first day
I want the range of days from Monday the 1st to Monday the 21st to read 21 days; yet it reads "22 days" in the duration column. This is because day 1 is the first day, when I need "day 1" to be the following date from the first day. Is there any easy way to fix this? In my job I can never count the first day as day one as…
-
Combine IF formulas in one cell
Hello, I'm trying to create a %Complete column based on a drop down list column called "Status". For example, I'm looking to combine these formulas into one cell, then copy and paste to all other cells in the same column. I'm very new at this and cannot figure it out. If there is a better way top accomplish what I'm after,…
-
Criteria for Alerts and Actions Rule
My boss has a Smartsheet set up to send a Update Request 30 days before today. For example row 7 would look like ....=[Due_Date]7 - TODAY() Would this alert still be sent if Smartsheet was down for maintenance at the scheduled time the alert was to be sent, or if there were conflicting "work week/full week" settings?…
-
Formula Help
Hello New user needing help with formula. I would like it to be something like this: When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green The idea is if a task is due today or tomorrow its red, if a task is due within 3-5 days its…