-
Return Previous status
@Genevieve P. or @Paul Newcome maybe you can help me with something. I have a sheet that i need to include some previous status column that i have in other sheet (probability Change log). I need that the status is the last row updated. In the sheet that i have the previous status i have the status and the "modified date"…
-
Trouble with IF AND formula - i need some help :o(
Hi everyone, need some help, I need a formula to display 5 different outputs based on the conditions set out below, I have tried this based on a IF(AND formula and not getting much back, I can get 4 and 5 to work using =IF(Cancelled@row = true, "5. Request Cancelled", IF([Upload to IMS]@row = true, "4. Request Complete"))…
-
Formula Help Please! Concatenate columns with delimiter & no delimiter for blanks
Hello - any help on this would be amazing. Example worksheet attached and issue below: I'm trying to concatenate 4 columns of emails to create one column of all emails seperated by a semi-colon. The email columns are not side by side and there is a mix of blanks in the email columns. Everything I tried is leaving the…
-
Index/collect returning #no match when there is a match
I keep getting a #NO MATCH when clearly I can see the match. I have used index/collect nested in several IF functions with success, but I cannot see why I'm getting NO MATCH here/ =INDEX(COLLECT(ActualNAR:ActualNAR, Mth:Mth, 3, SCML:SCML, SCML@row), 0)
-
How can I move columns from a row to individual tasks/ rows in a different sheet?
I am trying to conduct a survey at 100+ locations and use the survey results to generate a "custom" action plan for each site based on the responses. Once the action plan/ task list has been created I will need to track the project status of the task completion. The logic for the action plans is easy to address. I'm having…
-
End Date Formula Work-Around when Dependencies are Enabled
Hello! I am working in a sheet where I need dependencies enabled because we are using the GANTT view to show in a report on a dashboard, however I also need the end date of that sheet to be calculated (it is calculated based on another date in the same row). When dependencies are enabled, I'm not able to put a calculation…
-
Using countifs for multiple criteria
I have used the following which results in 'unparseable'. What's wrong with the formula please? =COUNTIFS({P&P report - AH - 15 Jun 22 Range 1},[Primary Column]@row), COUNTIFS({P&P report - AH - 15 Jun 22 Range 5}, "1"))
-
How to concatenate multiple IF statements' texts
Hello! I'm new to Smartsheet. I have a sheet that used to be in an Excel file. There's a column call "Currently Delay (Rolled Up Reasons)" which I'm having trouble creating. The original Excel formula is: =IF(AU6="Yes", CONCATENATE( IF(AND(AE6<>"", AF6 > TODAY()), $AE$3 & " ","") , IF(AND(AG6<>"", AH6 > TODAY()) ,$AG$3 & "…
-
Formula for: %Complete to be automatically changed to 100% when Status is updated to Complete
Hello community! I'm looking for this formula: %Complete to be automatically changed to 100% when Status is updated to Complete _ and, I don't think I can put a formula in the %complete column so where would I put it??? Thanks!
-
Summary Count of Status by Assigned Person
I have been racking my brain for a bit to figure out a formula for a summary sheet that will give me a count of each status (not started, in progress, complete, at risk) by the user assigned. I am trying to pull this information from my project sheet. I have a summary count for each status but I cannot seem to add the…
