-
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…
-
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…
-
Nested Formulas
Hello Smartsheet Community, I have been attempting to create an automated formula in the status column. I tried the following two options. =IF(AND("Complete" , IF([% Complete]4=100% , "In Progress" , IF([% Complete]4<50% , "Not Started" , IF([% Complete]4 = 0%, "Completed", "error"))))) =IF(Finish4 < TODAY(), [% Complete]4…
-
Find First Duplicate in a Sheet
I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
-
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…
-
Auto Populate Dates
Hi All, I have a smartsheet and am unsure the work arounds with date formulas. I have two columns one referencing when a task should be completed and one with an actual delivery date of task. I am trying to enter in something to auto populate dates for these tasks based on the initial start off date. Can anyone help me…
-
How to tell if Multiple Invoices have all been processed
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Formula
I'm looking for a formula that would let me update the status column when the %Complete has a value entered. It should read if 0% is entered Status would be not started; if a value of 1-99% is entered then it is in "Progress" in the status column. If the % Complete value is 100% then the status column would show "Complete"…
-
copy formulas from one sheet to another
I have created a block of formulas 4columns x 13rows that are each unique (with complex COUNTIFS formula) counting values etc. with different features. I would like to copy this formula block to another identical sheet. When I copy paste directly or ask it to copy the rows to the new sheet the formulas are erased and only…
-
Split Text to Columns Using Formula?
If I have a column with text like this: Mac:Air Mac:Pro Lenovo:Yoga Using formulas, how can I pull the data that comes before and after the semicolons? I want to end up with 1 column like this: Mac Mac Lenovo And another column like this: Air Pro Yoga Thank you.