Hi there!
I'm no excel or Smartsheet formula wiz but I'm hoping someone here can help me figure out a way to do the following:
I'd like an auto-populated number to appear in a row when the "Estimate" box is checked. There will be some rows where estimate is not checked and therefore I don't want to dedicate a row to a number that will make other out of sequence
I have columns Number, Estimate, Pk
[Number] [Estimate] [Project Name]
000001 X 20-TEST-JOBA
20-TEST-JOBB
000002 X 20-TEST-JOBC