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 …
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 …
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 …
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 y…
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 ther…
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 …
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 t…
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 …
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…
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
