IF(
Discussion List
- Hey there, I was wondering how I would tell the sheet to read a cell and IF the requirement is met it would generate a value otherwise, run a formula. So something like, IF( "Total Deposit Paid" = 0 t…
- Hi there, I'm trying to figure out a formula to return a Green/Yellow/Red Symbol based on a calculation of the date an item was purchased in comparison to the length of the service contract. I am able…
- Hi Smartsheet community! I am trying to find the maximum value in a range with both Vertical and Horizontal criteria. I was able to get the answer I need for a similar column using SUMIFS to add all t…
- Please help! I am trying to create an automation workflow in which I can send an update request whenever ANY OF Column A, B or C HASNT been updated within the last 14 days, however if ANY of these 3 c…
- So I have a sheet where different fellows enter their budget through a form. I am trying to copy the budget from a certain fellow in the T&E Descritionary column on the basis of the submitter's BIN Nu…
- I have created a budget sheet template and need to add seasonlisation to identify cross-charges by month. Rather than doing this manually every time, I would like to add a formula that pulls the data …
- Hi, I've tried looking up other questions to answer this and got as far as this formula [=IF(Deadline@row <= TODAY(+14), "Green", IF(Deadline@row <= TODAY(+7), "Yellow", IF(Deadline@row >= TODAY(0), "…
- Hello all, I've run into an issue around what should be an entry level IF statement. I'm comparing numbers in two columns, one of which is derived from a time calculation. The formula is looking to de…
- Hello everyone I’m in need of some more help with the below formula: =IFERROR(NETWORKDAYS(SupQARevCompleteDate@row, PlannerRevCompleteDate@row), "N/A") I need to add a condition to first check if Supp…
- Hi - I tried using this formula =IF(Status@row, "Open", TODAY() - [Date of Intake]@row) And it's giving me INVALID DATA TYPE Subtracting the date of intake from TODAY() worked, so I think it's my IF f…