-
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…
-
Column Status Formula
Hi Everyone, I have a status column with the following options: Not Started, In-progress, Complete, N/A. I've created a formula if the parent row is set at 'Not Started' then the sub-task would automatically change to 'Not Started'. Same with Complete and N/A. In-progress needs to work a little differently. The parent row…
-
Parent Sum IF
I've tried a variety of calculations, and can't seem to get the results I'm seeking. I'm simply trying to add up all of the parent rows in a column called Resource Days that are Assigned To a specific team member. Any suggestions? =SUMIFS(PARENT(Resource Days:Resource Days), [Assigned To]:[Assigned To], "Team Member")
