-
Counting for a Blank Cell
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 I add so it stays blank if I have no date in "[Completion Date]3". THANK YOU!
-
Formula help
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 also want to return "Yes" if the cell is blank. current formula: =IF([Days since last clean]1 <=…
-
variance
I have two numbers or dates Baseline budget 100,000 Current budget 35,000 Variance is 65,000 If I do a % calculation (variance/baseline) then its 65% I have a health indicator that says if the variance is > 10% then red, more than 5% and < 9% then yellow, lower then green. However, we are WAY under budget in this example…
-
SUMIFS of a value that falls between a rolling date range
Good Morning, I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns: Job Type Planned Start JSH *job site hours* What I need is to calculate the sum of total JSH if the job falls…
-
IF formula mix AND & OR functions, dates on modified and created columns
I'm looking to add a formula which will check the dates in modified and created columns and update the status column. If the modified date is today and is greater than the created date I want to populate the Status column with "updated", but if the modified date is equal to today and if the created date is also equal to…
-
How do I get my "IF" formula to automatically add to new rows?
We use zapier to add rows to the top of our primary active sheet from Pipeline. Within the active sheet are formulas set up for adding dollar amounts and hours. When a new row is added, these formulas carry "up" to the new row added in. However, I have an "IF" statement that will translate zip codes into cities (below).…
-
Stop Modified date updating for formula cell/column
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 day the value is "Not Updated", but then the modified date updates after saving, because the formula has…
-
Auto-populate a cell based on column dropdown
Hello, and many thanks in advance for your help. I'm new to Smartsheet and spent some time looking through the various answers on this community forum and could not figure out the answer to this question. I've attached a screenshot of a smartsheet I've made. I added a section at the bottom of my sheet called Reference. My…
-
Pull account name from another sheet???
Hello, I need help with the following. I am buildig a sales pipeline tracker. On one sheet I have a list of master accounts. On the tracker sheet I have a column named account list. Can I do a lookup/dropdown to get the account names from the other sheet? I want to ensure the account names are typed correctly by doing a…
-
formula help
i have a checkbox column that registers a check mark when an amount is over $100. The sheet has a form for collecting data. i put in a the formula =IF(Amount20 > 100, 1, 0) in the checkbox cell. Only when data comes in from the form, it puts new data at the bottom of the sheet below the formula. how do i get the formula to…