-
Blank display value for Symbols type?
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the green Up, yellow Sideways, and red Down arrows. Issue is, also need to display a blank in that status column if none of the…
-
IF Formula Based on Selected Quarter
Hi, I would like to write a formula that selects the appropriate sales tax rate with each quarter. I think I may be missing something basic when if comes to IF formulas...Does it matter if the sales tax column was created as a dropdown list? Is there a limit to the length of this formula if I were to add on with future tax…
-
Sumifs formula help
Hi, I am putting together a sumifs formula and it works for all criteria except this situation: With my working formulas, my range is just a column value but now I need a formula with the same criteria but I need to range to be the sum of 2 columns. This is my working formula with a single column range =SUMIFS({2019 Master…
-
Date Formulas
Is there a way in data matrix to do a formula to count the the number of lines with a due date today to 30 days out? I am trying to see item that will hit in the future.
-
Set Return Date as today +5
hi there, i have a form to manage my graphic designer's projects. It includes a To Graphics date and Return to You date. How do I set the Return to You date to be today +5 or greater?
-
Formula DATE
Hi I'm trying with the formula = DATE subtract months but I get #INVALID EJ: 05/18/2020 to 12/18/19, when I say that subtract 6 months I get an error but if the subtraction is within the same year the error does not come out, how should the formula apply? Thank you
-
Formula Help
I have an at risk column with flags. I am need a formula that will turn the flag red when its past a due date, and not marked complete. I used this formula =IF(AND([Date Needed By]1 < TODAY(), [Cabinet Complete]1 = 0), 1, 0) this works for the current row, but when I drag down to copy to cells below, it automatically turns…
-
% Planned formula
Hi to all, I need to add a % Planned to my plan. I used a formula but it didn't work. Attached you have a screenshot of my plan with the formula and the dates columns. Thanks for your advice!! Adelina
-
Trying to Sum Rows that Contain 'Countif' formulas
Has anyone had any trouble counting rows that contain a countif formula? I have tried to sum all corresponding cells and have also tried to count all the children lines and the value does not calculate correctly. My values within the children lines do contain some 0 values but there are no blank lines. Any suggestions?
-
Count values between dates dependent on another column value
How do I write a COUNTIFs statement to say if value in column A = "City", then count the dates between 1/1/2016 and 12/31/2016? Thanks!