-
Dashboard Widget Chart Issue with Multi Select
I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing something? Is there a formula that I can use to pull in that single option + any combination…
-
Formula to Automate Stage
Hello - I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns. Activities with a Start Date in the future would be 'Not Started', activities with a Due Date in the past would be 'Completed' and anything with a…
-
Return value in Parent Cell for Child value
I have been trying to use the Index & Match function to automatically populate in the Parent row based on the status of a Child row, however, the formula will not pick up the Child status. For example, I want the STATUS column of the Parent row to populate with the STATUS of the Child where the Child DOCUMENT TYPE = "Trust…
-
Dynamic reporting across multiple sheets
My organization recently moved from Google sheets to Smartsheet. We were tracking the number of jobs completed by each team member in the last week. We had multiple groups of jobs that would be uploaded as a new tab on the sheet. The reporting we had set up was able to search the new tabs for data to include in the report.…
-
AVG(Collect) Formula help with date range
Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19 =AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, DATE(2019, 10, 29)))
-
Calculate Date Employee turns 18
Can anyone provide a formula that calculates when an employee turns 18, based on a DOB (date of birth) cell. I've reviewed the forum and found formulas that return an age, but we need a date so we can set up a notifier email to alert payroll for some HR requirements.
-
Formula Help!!!
I'm having issues with making this formula work for the RYGB Balls. Any glaring mistakes? -Green – An open request that was received 1-5 days ago. -Yellow – An open request that was received 6-10 days ago. -Red – An open request that was received more than 10 days ago. -Blue - Complete -Blank/No Date - Blank status…
-
Formula issue for conditional formatting
I am trying to set up a formula to allow for conditional formatting but having some problems. This is the formula I'm trying: =IF([Actual]19 >= [Target]19, IF([Actual]19 < SUM([Target]19 * 0.1), IF([Actual]19 > SUM([Target]19 * 0.1), "GREEN", "AMBER", "RED")) but the result leaves the cell blank with no error message. What…
-
Forms/Formulas
Hi, I have a Form/Dashboard on Smartsheet to book site induction on the project I am currently working on (see attached image). Just like every other Smartsheet forms, once the form is filled in it feeds into the sheet. Is it possible that once someone books an induction late (48 hours prior to the induction date) they get…
-
Conditional Formatting if Checkbox is Checked
Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly for aesthetic purposes as I don't want to have my sheet multicolored all of the time. Using…