Hi, I'm trying to setup a nested IF statement to do the following: If DONE is checked then change the Status to Blue. If Due Date is more than 8 days out then make it Green. If Due Date is 7 days or l…
Is there a formula window available so I can edit/create long formulas better? The one the pops up when you start typing in a formula overlays other cells and makes it difficult to select columns int …
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of…
Looking to have an update request that would create a new row (much like a form would do). Here is the situation: - Row with Project Name, PMs, etc... A PMs has more than 1 project. I need to calculat…
Hello! Smartsheet newbie here:) I was trying to use a simple SUMIF formula to calculate the total number of days for a specific field. For example: I want to add all the days or duration for all proje…
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, …
Does anyone have a work around for cell-linking a contact list column that is used to calculate Resource Management and Conditional Formatting without creating another column? Issue - Person assigned …
Hi all, Is there a way to have a date/time field on a form look up data in a separate sheet to populate itself? I'm setting up a form for people to select a date and time slot to attend a training ses…
I already have a formula created that automates the RYG ball based on due dates... =IF(Complete1 = 1, "Gray", IF([Due Date]1 < TODAY(+3), "Red", IF(AND([Due Date]1 >= TODAY(+3), [Due Date]1 < TODAY(+7…
Hi all! I'm trying to figure out the formula for how to sum the number of check boxes from the parents. I have the children figured out but it is the summing of the parents that isn't working. (See Pi…