-
How do you automate a status updates in smartsheet with IF formula?
My organization would like to automate the statuses in a project plan. Could we create an IF formula to accommodate this logic? Examples: If the start date is in the past and the percentage is 0%, put status in yellow If the percentage is 100%, put the status in green If the end date is past due, put the status in Red
-
Hi All
I am trying to do a COUNTIFS formula in the summary field. II can get it to work with COUNTIF, however COUNTIFS returns an error (Unparseable). I am trying to get a count from two columns in the sheet to calculate in a summary field Column 1 - Status Column 2 - Unique I wrote =COUNTIFS(Status:Status, ="Open",(Unque:Unique,β¦
-
IF with MAX(COLLECT issue
Hello! I am stumped by a problem I'm working on. Part of my work is to assemble a dashboard that shows the maximum number of occupied beds at several homeless shelters in a given period of time during the previous night. Supervisors at each shelter, hour to hour, complete a survey that asks the number of occupied bedsβ¦
-
Formula- need to Sum OR Average based on another cell
I need some help with a formula. I have: =IF([Goal Calculation]@row = "sum", SUM([Quarter 1]@row:[Quarter 4]@row,IF([Goal Calculation]@row = "average", avg([Quarter 1]@row:[Quarter 4]@row)))) The problem is it is only updating to reflect SUM. If I change it to AVERAGE, the cell goes blank. So I switched it and put AVERAGEβ¦
-
ADD LAST COMPLETE DATE
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last column that changed to "complete" status. I really appreciate any help! Rob
-
Clearing a Value and Setting a New Value
I have an automated workflow created to set the date when a disposition (decision) has been reached on a request. There is a column to capture the disposition (decision) type and the date of the (disposition) decision. We would like to be able to change the date when a new decision has been made. Specifically, when theβ¦
-
Appointment Scheduling
Good evening, I am trying to find the best solution in Smartsheet for a remote call center to utilize to schedule appointments for multiple locations. There will only be certain time slots available for each location? We are currently using separate sheets for each location and would like to incorporate into one, possiblyβ¦
-
Track Weekly Progress Against Goals
We have a bucket of funds to use by a specific date. There is a weekly goal $500k in requisitions I have a grid that tracks all the requisitioned amounts and the date they were approved. What is the best way for me to capture the week-to-week progress so I can create a chart that visually shows if the $500K goal is metβ¦
-
Boolean Blank if cell is blank?
I am trying to create a boolean formula in which if the cell is blank the formula does not apply.... below is the formula I currently have =IF([Av3000 Due Date]@row <= TODAY(), "Red", IF([Sure Seal Due Date]@row <= TODAY(), "Red", IF([Half Face Due Date]@row <= TODAY(), "Red", IF([Weld O Vista Due Date]@row <= TODAY(),β¦
-
Can I use a SUMIF formula to sum children rows?
Looking for help on writing a formula to be located in the Parent Row under the Forecast column Row 1 to sum children rows of all Salesperson except Mike. I manually entered a formula =Value2 + Value3 + Value 5 in the Parent Row (90% Closing) Forecast column Row 1 to get the sum total of $700,000 that I am looking for, butβ¦