-
Formula to count fields that are not blank
I am just getting familiar with smartsheets and am having a problem convert a spreadsheet that contains a formula that I really need. This formula currently works well in Excel to count cells that contain dates so if any cells are blank it won't count the cell. This is the formula that works in Excel…
-
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