or Explore Discussions

# Formulas and Functions

Archives for May 2019

## Discussion List

• Checkbox if Date Past Due AND <100% Complete OR In Next 10 Days AND <100% Complete
In Formulas and Functions
Hello, I am trying to create a formula that will automatically check a box if a due date is past due AND % Cmplt is not 100% OR due date is in the next 10 days AND % Cmplt is not 100%. Basically, I will pull the checkboxes items into a re…
148 5
148 views 5 comments Most recent by Paul Newcome Formulas and Functions
• How to put together two formulas to account for blanks
In Formulas and Functions
Hello, I have this formula to add 10 days to a date: =[Date1]@row + 10   Then I have this formula to leave blank if there is no date: =IF(ISBLANK([Date1]@row), "") I need to put them together so if there is a blank the cell …
12 3
12 views 3 comments Most recent by Andrée Starå Formulas and Functions
• Counting for a Blank Cell
In Formulas and Functions
Hello! I have this formula that works great: =DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3))) But if my date in "[Completion Date]3" is blank it throws off my whole formula. What can …
31 8
31 views 8 comments Most recent by Paul Newcome Formulas and Functions
• Formula help
In Formulas and Functions
Hi, I am working hard to get my head around formulas and have managed to get the correct return with the below formula, if greater than 14 days then return "Yes", if less than 14 days then return no. Where i am struggling is i a…
1 3
1 view 3 comments Most recent by Andrée Starå Formulas and Functions
• Sumif Formula
In Formulas and Functions
Hi, I'm having problem with my formula below.  If I update the column 2 to reference "Amount Invoiced", it automatically change the formula in Column 1 to "AmountInvoiced".  I need Column 1 to only reference  PO Amount…
4 4
4 views 4 comments Most recent by Andrée Starå Formulas and Functions
• Return value if one condition is met
In Formulas and Functions
Good Morning, I am trying this formula within my sheet in a brand new column: =IF([Planned Start Date]@row - 21 <= TODAY(), [Estimated Hours Number]@row, "") For this column, if someone put a date that falls between today a…
555 6
555 views 6 comments Most recent by Paul Newcome Formulas and Functions
• Flag task as late where task incomplete and past due date
In Formulas and Functions
342 2
342 views 2 comments Most recent by leezee Formulas and Functions
• Stop Modified date updating for formula cell/column
In Formulas and Functions
Hi, I have a formula in place to have a certain value in a cell if the modified date is today "Updated", and if not display a different value "Not Updated". However, this seems to work when I open my sheet the next da…
115 1
115 views 1 comment Most recent by Andrée Starå Formulas and Functions
• Removing System Generated column (Date) contents
In Formulas and Functions
I have completed building and testing my sheet and Dashboards. I now want to remove the System Generated Date for all my Form entries used for testing. If I remove the column and reinsert it, the formulas dont work. Is there a simple way o…
24 5
24 views 5 comments Most recent by Andrée Starå Formulas and Functions
• Automatically Track Inventory Usage
In Formulas and Functions
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program.  I'm hoping there's a way to automatically track inventory usage base…
456 6
456 views 6 comments Most recent by Carolina Martins Formulas and Functions