-
Returning Open or Closed based on conditions
Referring to Row 6 I have a Status column and that can be Open or Closed. It depends on the condition of the Progress column which can be selected from the following dropdown menu. The first 4 conditions mean the Action Item is “Open”. The last condition means the Action Item is “Closed”. Dropdown: - Not yet submitted -…
-
Combining multiple SUMIFS into one formula
I have used and tried each of these formulas separately and they work beautifully. =SUMIFS([Total Savings]@row, Lane@row, "IL5" =SUMIFS([Total Savings]@row * 90 / 100, Lane@row, "IL4" =SUMIFS([Total Savings]@row * 50 / 100, Lane@row, "IL3" =SUMIFS([Total Savings]@row * 10 / 100, Lane@row, "IL2" =SUMIFS([Total Savings]@row…
-
Adding an additional requirement to a formula
We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data. =SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1}) I now need to add an…
-
Nested IF(AND OR(IF(AND Statement
I am trying to identify which projects need committee review vs those that can be auto-approved. I have 5 columns with the following selections: - Currently Underway? - Checked/Unchecked (I want values that are unchecked/=0) - Helper - Timeline - Returns Yes/No based on formula. (I want values that = Yes") - Helper - Count…
-
VLOOKUP cross-sheet, if the search value's parent = @row
Hi all, I'm trying to populate an entire column on a sheet using both cross-sheet and in-sheet references. I'm trying to return a value according to the following logic: Looking for cells cross-sheet that contain "Opening Date" and returning the value from the cell to it's right (also cross-sheet) if that particular…
-
IF AND Formula Workaround
Hi All I am trying to get a formula working whereby if * END DATE is in the next 3 days * END DATE is not blank * Status is either (In Progress, Not Started) * At Risk flag will be indicated (, 1) Many thanks
-
Multiplication with @row or @cell formula
I like to use the @row or @cell in a multiplication formula and be able to copy this for all months. where do type in @cell?
-
Announcing 24 New Formulas!
Each year, Smartsheet hosts a hackathon called “Hack the Sheet.” During this hectic, exhilarating, and productive week, our entire product and engineering teams get to work on projects they are super passionate about. We divide ourselves into teams based on interest, have some late nights, and are judged by peer and…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
Displaying range of dates on a Dashboard
Hi Smartsheet Community, My team currently utilizes a report with multiple sheets to track the due dates of projects. We currently use the Calendar app to display this info - but I'm looking to build an additional dashboard for my team that will utilize this report to display the upcoming due dates in a two-week window.…