-
Is there a way to track the number of work days in each "Status"?
I would like to track the number of work days an item is in each status. For example, an item was in Feasibility Assessment status for 3 days and UAT status for 8 days. Is there a way to do this in Smartsheet without using a third party tool?
-
Converting UTC timestamp to Hawaii Standard Time timestamp
I've been importing data from Toggl (toggl.com) using Zapier (zapier.com) to SmartSheet. The date/times are recorded in Toggl in UTC, and I'm trying to convert this to HST (i.e. -10 hrs). My settings are for HST. The UTC format: 2019-03-15T02:43:21+00:00 I've tried several suggestions in other posts/solutions for…
-
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!