-
Future Date Calculation
Hi I'm trying to convert an Excel formula to Smartsheet formula: Excel formula =[Installation date]4+(365*[Warranty Expiry]$3) Aim is to give a future date when the warranty will expire x years after the piece was installed. Thanks
-
Countifs same column different criteria
Hi I'm trying to count the items in the in one column if they are not equal to criteria in another column. May someone assist. This is what I have so far. =COUNTIFS({FDA Submission 2019 Range 1}, "DE Novo", {FDA Submission 2019 Range 2}, OR(@cell <> "Approved", @cell <> "Rejected", @cell <> "Withdrawn")) However everything…
-
Changing cell to "0" if checkbox is checked
Wondering if it is possible to change a cell to "0" if the checkbox is checked. I'm assuming a formula will need to be used since I was unable to find it in the conditional formatting. Thank you for your help in advance.
-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
-
Formula Count Help
May I please get assistance with a formula? I am trying to do a formula that references another sheet (Loaner Sign Out Sheet), which calculates a total from that onto my Request Metrics sheet. Please see attached. I would like a total count for Request Type "HDMI" only if the Status states "In Progress." If it's not in…
-
Is there a way to use SumIF to add values in a column that match a specific text string in adjacent
We are building estimate sheets using a hierarchy based on Construction Specifications Institute's organizational coding system. I have rows nested using multiple parent / children. The top level is the CSI Division, which has children rows with specific categories within that Division, and each Category line has nested…
-
IF(INDEX(MATCH formula
Hey folks, Thought I'd reach out to see if anyone could assist with my IF(INDEX formula. The columns involved with this one are Today's Date, Date2(abbreviated name for the day), daily sales qty's. I have a Dashboard where I return/display the Qty for the previous day's sales. My issue is, the formula in it's current state…
-
Formulas
Is is possible to write a formula based on information in one sheet to put the result in a cell of another sheet? I want to sum items if they meet certain criteria in one sheet but the result going in a cell in another sheet. Thanks!
-
Date Formula Needed
Hi, I am trying to subtract two dates and have it return as the number of years. I have not been able to find any "date" formulas that will work. Any ideas? See screenshot
-
Auto Date Calculation
Hi Very new to SmartSheet, I am trying to create a Purchase Tracking sheet that can be used for Payment Schedule. Here is what I have " Invoice Date" This I put it manually whenever I receive an invoice from my vendor. I also have another cell "Droplist" which state payment terms like 30/60/90 days. What i need is 1) A…
