Is there such formula to capture under list of project all the projects (in this case 3) that have the benefit of Efficiency Gain from a cell that contains several benefits?
I believe this is already being worked on 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
I need to calculate the number of Network Days based on a Leave Status but if a half day has been checked, it needs to just put 0.5. The formula I am currently using is: =IF(AND([Half Day]@row = 1) [Leave Type]@row = "TOIL", "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row)) But I'm getting a #Unparsable error. What am…
Hi, hoping someone will be able to help with an issue I am having with an IF formula. I am attempting to build an IF formula from check boxes, however it isn't as simple as multiple IF statements returning their own responses. What I am trying to achieve is a status update column, based off of the checkboxes. And therefore…
I created a timesheet and a form to go along with it. When someone uses the form and flags that someone has called off, I want the flag to return zeros in the ST Hrs, OT Hrs, and DT Hrs cells. Using AI to generate the formula below, it returns a Circular Reference error when the formula is placed in the ST Hrs cell.
©2024. All Rights Reserved Smartsheet Inc.