Convert to Column Formula grayed out

System

System Employee

12/05/23 in Formulas and Functions

This discussion was created from comments split from: Convert to Column Formula grayed out.

0 ·

Answers

Atroyanek ✭✭✭

12/05/23

I am having the same problem with this formula: =NETDAYS([Date Started]@row, [Date Moved to IT]@row)
Any suggestions on how to get it to not gray out?

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
Help with "INDEX MATCH"
Hello, I'm kind of new to Smartsheet and I've been tasked with transitioning a lot of data into Smartsheets, with that said - I have a data sheet that I need to INDEX MATCH actuals into a forecast sheet. Whenever I try to enter an INDEX MATCH formula, it keeps saying that multiple criteria is not supported or the MATCH…
My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello, I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects…