-
Avg Formula on a Duration Column
I have read the forum and still having issues with this formula. I am simply trying to average the duration column. It returns a Divided by Zero error and have tried adding this into my formula. What is a sheet summary formula that would average the duration column. Any help is greatly appreciated :)
-
Formula that sums hours where a single value matches a value in a multi select list AND month
I am working on a formula that calculates hours worked where a member exist in a multi-value list and the month. The detail is recorded in Run Data Sheet. Each record provided the date of the run, start and end time of the run, hours (difference between time in and time out), multi select list of the members that were on…
-
How to create date picker in Smartsheet?
Hello everyone! Is it possible to create a date picker in smartsheet? - I am attaching an example below. I want to have one column where I can quickly choose a date. I know that it is possible to create it in excel, but I can't find guidance on how to do it in smartsheet. Thank you so much for any help :)
-
#unparseable error
=SUMIFS(Current Headcount:Current Headcount,Manager Region:Manager Region,"US-West") Trying to add up headcount for US-West region. Summing head counts in the "Current Headcount" column where the Manager Region column has us-west selected.
-
Count If formula for multiple items within 1 cell
Hello all, I am trying to generate a report from a Smartsheet (that is auto-populated from a form) that will give me a total count of how many people have access to which event space, per day requested. Since each cell could have 1 or multiple values, right now my CountIf formula is only correctly calculating the cells…
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
-
Formula for parent arrow to change based on the average child arrows
Hi all - I need help with formula to average the arrows and show the appropriate arrow based on that average, i.e. if majority of arrows are down, then the arrow in the orange section would be red, etc. Hope this makes sense.
-
Setting up VLOOKUP correctly
Hello, I have a source sheet that has a unique ID, and I use that as a reference to generate a number of references in a second sheet for extra details. I am using VLOOKUP to bring about 10 columns from the source sheet into the second sheet. The typical formula looks like this: =VLOOKUP([AOP ID]@row, {2023 AOP Entry Range…
-
Return First Non Blank Value within Children Range
Hi, I am currently getting a circular reference error with the formula below. What I am trying to gather is the first nonblank value within the children of a reference Parent Row. =IF([Company Name]@row <> "", INDEX(COLLECT(CHILDREN([Company Name]@row), CHILDREN([Company Name]@row), @cell <> "", CHILDREN([Company…
-
Is there a workday.intl equivalent in SmartSheet?
I am looking to pull in a google sheet used to manage project schedule that uses a 6 day work week to calculate schedules. For example one cells formula is: =IFERROR(if(E69="Mail Date", F69,if(G69="First", workday.intl(AN69,-4,11,Holidays_USPS), if(G69="Standard",workday.intl(AN69,-6,11,Holidays_USPS),"NA"))),"NA") Is…
