-
SUMIFS - Multiple Formulas
Hi I am trying to calculate the revenue for each leg of an event. The drop down options are "Spring", "Fall" or "Both". Using the following statements individually I can get part of the answer: =SUMIF(CHILDREN(Roadshow21), "Spring", CHILDREN([Forecast Amount]21)) =SUMIF(CHILDREN(Roadshow21), "Both", CHILDREN([Forecast…
-
Nested IF Statement with RYGB Balls
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 less then make it Yellow. If Due Date is TODAY or in the past make it Red. This is what I have so far but it is not working.…
-
Is there an formula edit window?
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 he same row. I'd like to have a separate popup that I can move around on the scree or make bigger so I can see and work on a…
-
Keeping persistent dates for status changes
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 the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Update Request which create a new row
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 calculate the weekly hours for stats purposes. If I use a form, the PM must submit it and then click back on the email again and…
-
SUMIF Formula returning incorrect number
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 projects that were labeled as "Conversion" together to calculate the total number of days spent on all conversions. However, from…
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
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, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Contact List Cell-Linking?
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 to Task A needs to automatically be assigned to Task Z.
-
Lookup on a form?
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 session. I thought about having the list in a separate sheet and then only show on the form dropdown the sessions that are…
-
RYG ball based on due dates
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)), "Yellow", IF([Due Date]1 >= TODAY(+7), "Green", "Nope")))) What im having an issue with is whenever the cell in the due…
