need a value to display in column throughout
Hi,
I have a 2 part question. I need a numerical value to appear throughout a column without having to drag it down to subsequent rows. So .....
1.) how can I get that same value to appear throughout that column if maybe I just populate the top field in the top row in that column with that #.
2.) whether the above is doable or not, how can I get that same numerical value to appear throughout the defined column only if a different field is populated in the same row.
Thanks
Best Answer

Sorry missed that part, try this
=IF([W/O #]@row <> "", 60)
Convert to column formula
Answers

I have a formula that enters the Item Type (in this case, Risk) if the Description field is not blank. Sounds like you'd need something similar.
=IF(Description@row = "", "", "Risk")

Thanks. Syntax seems off and incorrect.

Ok so here are the actual columns. I tried the suggested formula but it didn't work and that may very well be that I entered it incorrectly. What would be great is if whenever any value is entered in the W/O # column, the number 60 appears under its respective column. Only reason for this is to alleviate the dragging of the column by one of the Admins in order to populate new rows for which there are a host of new rows being added to the sheet every day. Thanks in advance.

Enter it as a formula =60
Then convert to column formula

That works and thanks. What would be ideal is a formula for whenever ANY value in the W/O # column then returns the 60 in its respective column thereby leaving all other fields in the 60 min Calc. column blank. Thanks

Sorry missed that part, try this
=IF([W/O #]@row <> "", 60)
Convert to column formula

Did the trick ... thanks Paul.
V_
Help Article Resources
Categories
Check out the Formula Handbook template!