-
Need help with CountIF formula referencing two columns on another sheet with an OR statement
Current attempt: =COUNTIFS({Sheet Name - Standard}, CONTAINS("UM", @cell), {Sheet Name - Annual}, OR("yes", "add")) The gist is, another sheet, Sheet Name, has a column, Standard, and a column Annual, and for every Standard that is UM, we want to count if the Annual column contains "Yes" or "Add". There is a third option…
-
How to get the Delta between Estimated Duration and Actual Duration
Good Morning, We are trying to move our deployment plan for technical project implementations into Smartsheet. What I'm struggling with is getting the delta between estimated duration and actual duration to account for working days only. My start date/time, end date/time and actual finish date/time are all manual input.…
-
Broken Vlookup (No Match)
My vlookup is returning no match even though there is a match avaliable. But the reference sheet has an avaliable rate:
-
Can you extract text from a cell to use within a formula of another cell?
I'm trying to dynamically update the lookup_table value in my VLOOKUP formula based on a selection made in another cell. Thank you, Matt
-
how to overcome blank cell errors when adding days to a date ??
I have added days to a date (=[Date Inputted]@row + [Timescale (Up to __ days)]@row) However how convert I the error (invalid operation) to a blank cell in the estimated completion date column?? (if error does not work, attempted if formulas but then the days do not add to the date) Help appreciated :)
-
How can I add a number of days to a date column in the same sheet?
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
-
Formula Help
Good morning Community, Please could somebody help me figure this out. When the schedule date = today, the status is turning red, whereas it should be yellow. Any date past today should be red only. I hope that makes sense! =IF([Scheduled Date]3 = "", "", IF([Date Completed]3 <> "", "Green", IF([Scheduled Date]3 <=…
-
I want to be able to achieve a line graph overlaying 2 types of events " Incidents" & Planned Event
I want to be able to achieve a line graph overlaying 2 types of events " Incidents" & "Planned Events" and plot Dates down here. The way I have it setup and the only way I can figure it out is to have the "incidents" I am counting by Month for the X axis. But it is a range of incidents that span 2022 and 2023 here and I…
-
Help with Sumifs Formula
Hello, I am trying to sum totals in one column based on criteria in three other columns. Sum of totals in one cell based on the approval status, classification of the expense in the other columns. =SUMIFS(Total Projected Cost:Total Projected Cost,Classification of Request:Classification of Request,"T&E",Approval…
-
Update formula wizard when used in sheet summary
This is because the wizard only offers 'Reference another sheet' when this is slightly illogical as you are in sheet summary ie to summarise the sheet you are in. You then cant click on the column header to add the range to the formula when using sheet summary without an error. The way to add the range is to scroll down…
