-
Conditional Formatting Stopped Working
I have some very basic Conditional Formatting rules based on a System Date "Submitted". They were working fine, but today they just stopped working. I have attached a screen shot of the rules. Any idea why this would suddenly stop working?
-
Net Days Formula Help, Please!
I need some help with these netdays formulas. I'm struggling with the best solution for excluding the blanks in the Date of Dis-enrollment column. I have the netdays formula applied to the Length on Enrollment column with today as the end date. However, if there is a dis-enrollment date, then that dates needs to be the end…
-
Ideas on how to strip file extensions from a file name?
Let me explain my scenario: User posts a document to SharePoint Via Power Automate, Smartsheet is notified that that document has been posted in SharePoint. This notification contains the full file name from SharePoint (including .docx, .xlsx, .txt, .jpg, whatever file extension). In order to associate this event to the…
-
#INVALID DATA TYPE for some functions using DATE
Hi: I am trying to generate a sum (cumulative) of all effort "points" for projects started in the current year. CASE 1: My reference columns are: "Project Start" (date) and "Effort Count (Est. Total)" (text/number). I used the formula: =SUMIF([Project Start]:[Project Start], YEAR(@cell) = 2020, [Effort Count (Est.…
-
Formula: Turn Sprint # into Date or vice versa
I'm attempting to create a formula that will translate Start Date into sprint number. In my spreadsheet there is a column for Sprint that I'd like to populate it with Sprint 1, Sprint 2, Sprint 3, etc based on date. For example Sprint 1's start date is 12/11/19, Sprint 2's start date is 12/25/19, etc, increasing in two…
-
Sumifs with multiple criteria and cross-sheet referencing
Good day, I am struggling to get the formula for sumifs. I have used both options below but it does not work. SUMIFS({Description} = Description2_{Stock Request} > 0; [{Sub-warehouse}; "Brandon"]) SUMIFS({Description} = Description2; {Stock Request} > 0; {Sub-warehouse}; "Brandon") I need the quantity to be summed if the…
-
Adding formula to existing formula for status change
Hi everyone, I currently have a formula in my status column that auto-update depends on the percentage completion. Anything that is 0 is Not Started, and greater than 0% and less than 100% is Green (G), and anything that is 100% is Complete (blue). I want to add 2 more actions in the formula. If Finish Date is in the past,…
-
How do I use conditional formatting to highlight upcoming dates that do not match?
For example, I am using cell linking to pull in two different large pieces of data from two separate sheets. What I'm trying to resolve is how to flag column 3 date if it does not match column 2 date. I want to highlight the dates that don't match so we can resolve as to "why", internally. Thank you for your help with this…
-
Insert Formula within Workday "num_days" string
Hey, This may be super simple & this feature is available in excel, so I think i am just missing something in front of the "-1" for Smartsheet to pick up a formula. I am trying to calculate the day for a "test" shipment to arrive, based on 3 factors - 1. workday (with holidays), 2. Scheduled delivery date of devices, and #…
-
How Do I Count the Number of Occurrences of Text Across Columns?
I am trying to count the number of instances that certain text occurs across columns in a sheet. How do I count the number of "F"s, and "P"s across these columns.
