When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to us…
I have written a simple formula to pull the date from one column into another on every row of my sheet. ( =[Schematic Prep]@row)....converted to column formula. Now logically I understand that there a…
Hello Community, I am trying to reference a page which has certain weights assigned to the categories which the users will select while filling out the form. Based on the selection of the categories t…
Hi there I'm struggling to get the syntax for a COUNTIFS(DISTINCT formula. I am creating a check sheet which counts only unique references against an SPV name. I have a list of the SPV names and I onl…
I am trying to turn text in a status column i have shuttled over using data shuttle from Excel into Smartsheet into a traffic light symbol. My column is Called Status, and the text in the column is gr…
I am struggling with a formula how many times Delta appears in the Client Column. The formula I am using is: =COUNTIF((Client:Client), FIND("Delta", Client:Client, >0))
I have a column that shows how many days have passed since a start date. I would like to add a column with an end date, and if there is an end date, have that count stop. So if the end date is blank, …
I'm stumped in this formula... I wish to perform a countif when a date is between two dates. I have a Start Date and a Due Date Column and in another sheet I have a list of days. and I want to count h…
Like the title says, I'd like to only show the number of days elapsed when the status is on Open. I'm currently using this formula: =IFERROR(NETWORKDAYS([Report Date]@row, [Due Date]@row), "") Any tip…
Hi, I am working on this formula,... What am I doing wrong? criteria 1 is the words --"2022 Donations" and criteria 2 is data between two dates for quarterly sum of $. =SUMIFS([Paid $]:[Paid $], Codes…
