We use smartsheets to log support queries. I want to calculate the turnaround time between two dates:
Date the ticket was loaded and date that the ticket was closed
Date format: mm/dd/yy x:xx PM or AM
Is there a way to calculate the turnaround time?
There are numerous solutions here:
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
=COUNTIFS([RACD]:[RACD]), DATE(24, 06, 30), [VPO/ED]:[VPO/ED], "Misterly" Trying to count number of accounts with an RACD Date of 06/30/24 assigned to VPO Misterly using the above formula and i keep getting an unparseable error. What am i doing wrong
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…
On my Smartsheet, I want to count the number of lots manufactured per year based on the date of manufacture. If the date is between 1/1/2023 and 12/31/2023, give me a value of "2023", and the same moving forward in 2024 and so on. I cannot figure out what the formula will be. Can someone please advise? Thank you in advance.
©2024. All Rights Reserved Smartsheet Inc.