-
NETWORKDAYS with IF
Hi I have a NETWORKDAYS formula that will calculate work days between a begin and complete date, but often our projects are paused, so I need a formula that will subtract the net work days during the pause. I figured that out, as well: =IF([Completed Date]@row = "", "", NETWORKDAYS([Begin Date]@row, [Completed Date]@row) -โฆ
-
Calculating the Year, Month, and Days for Tenure
Hello, I am attempting to calculate tenure in years, months, and days given the total # of days. I calculated the # of days between hire date and term date in 1 column (# of Days), and used the formula below in another column. It is not calculating correctly, and I am getting decimal numbers for the months and daysโฆ
-
Use of Averageif while filtering data in multiple columns
I am attempting to average %complete by team (Team#) where sessions are active (Sessions Scheduled). This requires two HAS(@Cell, Criteria) but I am getting an #UNPARSEABLE =AVERAGEIF([Team#]:[Team#], HAS(@cell, "1" AND [Session Scheduled]:[Session Scheduled], HAS(@cell,"1"), [% Story completed]:[% Story completed]) Howโฆ
-
SUMIF not working
Hi, I am trying to SUMIF to a range of VLOOKUP's where some of them result in #NO MATCH. And the SUMIF always gives me a #NO MATCH error. Can someone explain to me why this is not working and if there is a workaround. Thanks!!
-
INDEX-MATCH or VLOOKUP returns #INVALID REF when in COLUMN FORM
Guys, Smartsheet is returning #INVALID REF after transforming the column to column form. The formula is simple: = INDEX ({Standard Tasks Reg. - 2021 - BASE AME Interval 1}; MATCH (Reference @ row; {Standard Tasks Reg. - 2021 - BASE AME Interval 2})) or = VLOOKUP (Reference @ row; {Standard Tasks Reg, - 2021 - BASE AMEโฆ
-
Request for new functionality: Automated entry of cell-completer
Hi, I love the new automation features (e.g. automated entry of dates into a column). I would really benefit from similar automation for population of a column for the cell-completer (i.e. the person who made an entry into a cell). The flow would be similar to this: Automation is set up and enabled John Smith makes entryโฆ
-
Health status formulas and automation
Hi, is anybody able to help with automation formulas for the Health column? I'm very new to Smartsheet and struggling a bit! I'm trying to do the following: Green - Status='In Progress' and more than 1 week before end date, or status= 'Complete' Yellow - Status= 'In Progress' but end date 1 week away Red- Start date isโฆ
-
Can you make a forum/survey become a standardised template?
I have created a forum that I would like to share with my team who can use as a template for future reference ๐
-
Help with COUNTIFS Formula
Hello Everyone! Happy Friday! I am trying to create a Project Milestone Widget for my project dashboard. I want to be able to show the total number of tasks to be completed and the percentage that has been completed. I used this formula to get the number of total tasks for each project phase (parent row).โฆ
-
Adding various formula cells in a row
Hi Everyone, sorry if this is a bit basic but I'm new to Smartsheet and can't work out how to add several cells in a row that are in formula columns. I thought using the SUM formula shown below would suffice but it keeps returning a 0 rather than 200. Any help on this would be appreciated.