-
If Checkbox is not needed, show blank
Hello Smartsheet Gurus, I have a spreadsheet that has a few columns as checkboxes, but when the checkbox is not needed, I want the cell to show nothing. Is there a way to do that? Thanks, Arryn
-
Create a Formula that compares Dates in 2 Columns and Counts a Total
Hi all, I am trying to write a COUNTIFS formula that compares multiple criteria. I need to Count all items in a column that have a status of "Completed" (column A), IF the items also have an Actual End Date within 2019 (column B) , and the Actual End Date is less than or equal to the Scheduled End Date (column C). I cannot…
-
IF / THEN Formula help
Hello, Im quite new to Smartsheets and was hoping for some code assistance. What i am trying to do is as follows: 1) Search a column (column1) in another sheet for a value, say 5. 2) When it finds that value, count how many checkbox's in column2 has been ticked Im trying to use an IF([column1]=5, COUNTIF(column2),1),0)…
-
IF/AND Formula
I am trying to create a formula to track invoices that are completed under 30 days. If the number in the "Invoice Duration" is less than 30 I'd like the next column "<30 Days" to populate with "Yes" If the number in "Invoice Duration" is more than 30 I'd like it to populate "No" Thank you for all the help!
-
Calculating time
Hello Does anyone know if there is a way to calculate Time in smartsheet without using a 3rd party program? Thank you.
-
SUMIFS criteria headache
Hello all, Typically, building a formula through Smartsheet doesn't give me any issues but the SUMIFS formula specifically within Smartsheet is making me pull my hair out. I have 3 columns that I need to use in the formula. -Job Code -Needed Position Headcount -Building Status I need to add the total headcount of each job…
-
Formula -weighted for specific criteria
I have a complicated request. I want to create a formula that will provide a % when a row is designated as a "critical path" item. See screenshot. As a box is checked in the column for each cabin name, I want to get the % to update for those critical checked boxes. Is there a way to do this? I already have a formula that…
-
Totals of column data
Is there anyway to total columns other than using a parent?
-
SUM of consecutive cells until blank cell is reached in the column
Hi, i am trying to SUM any given number of consecutive cells in column A and need it to stop once a black cell is reached. For instance The SUM will be column A, row 2 to 6 (7 is blank) and I am wanting the SUM to display in column B row 1. This will repeat throughout the sheet, but the SUM result will always be column B…
-
Automatic Move
One of the ways I use smart sheet is to manage my work load. Once a project is completed, I move it to a completed row to keep record of it. Is there a way to automaticaly move a row once the staus has been change to "completed"?