-
Don't Count if Cell is Bank
Hi All, I am using a checkbox formula to count the status of a task. Is there a way to also include to not include blank cells in the count? My formula is =IF([1 Rough Draft Writing Status]11 = "Not Started", 1, 0) I want to drag the formula down but I also have rows that don't have anything in the status column because…
-
SUMIFS with multiple matches
I am trying to create a Smartsheet SUMIFS formula where if the value in a cell in column 1 is not blank, and the value in a cell in column 2 is US Commercial, and the value in a cell in column 3 is 2019 and the value in a cell in column 4 is 4.. I.e. for any rows where there is a match for - deal id is not blank, where…
-
Red, Yellow, Green
Formulas are not my thing. Can someone help me with a formula to display the following: If % complete column is 100% turn the ball green in the status column If % complete column is less then 100% but greater then 80 turn the ball yellow in the status column If % complete column is less then 80% turn the ball red in the…
-
Aging formulas in Smartsheet
Hi, I have a column titled aging and its the [created date]-[Today()]. The problem is that there is no trigger when the line item is completed/canceled, as a result it shows that that item is still currently aging in fact it has been completed/canceled. What I would like to do is build if possible and If statement that if…
-
Formula to create hyper link with display text defined
I want to be able to clean up/simplify how a link is displayed in a cell. Column A: the text I'd like to use for the link display Column B: the long URL with lots of URL tokens, folder locations, etc.. Column C: a clean, short, hyperlink made from A&B Example values A: Profile B:…
-
Trigger notifications based on dates previously input
Hi all, Trying to build 2 spreadsheets that need to communicate with each other at this level: One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, test required, etc. The other (second) spreadsheet will be a record of materials booked in. Will it be possible that, by…
-
NetworkDays but using different days
Hello, I am trying to creating a PTO form but we have users that work weekends. In Excel, there is a formula, NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays]), that allows to shift what is considered a non-countable workday. Is there a formula or a workaround for this formula? Note: This is not a Gantt sheet…
-
Joining the Results of Boxes Checked on a Form Entry (2 Solutions)
Edit: I had used numbers as my column names which in turn populated my first row. Another user made a good point that the number 1 in the first row will not actually duplicate my column name, but will read as "true" since it is a checkbox column. The column names and formulas have been updated to account for this. . I…
-
IF Function
I've been trying to find a way to combine various checkboxes to designate different status', for example: If this checkbox is checked then this is the status However, if that checkbox is checked AND this checkbox is checked, then it's in a different status If these 3 checkboxes are checked, then it's in a different status
-
Trying to expand my knowledge of writing formulas
Im having a little bit of a hard time trying to make formulas longer and saving column space(s). For instance when I run into an issue of creating a formula in 1 cell i sometimes create a new column and put the formula I wanted to add in there. This takes up space which can be free'd up and when the sheet gets over 1000…