need a value to display in column throughout

Options

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

Answers

  • JL2022
    JL2022 ✭✭✭
    Options

    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")

  • VinceA
    VinceA ✭✭✭
    Options

    Thanks. Syntax seems off and incorrect.

  • VinceA
    VinceA ✭✭✭
    edited 03/28/22
    Options

    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.

  • Paul H
    Paul H ✭✭✭✭✭✭
    edited 03/28/22
    Options

    Enter it as a formula =60

    Then convert to column formula

  • VinceA
    VinceA ✭✭✭
    Options

    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

  • Paul H
    Paul H ✭✭✭✭✭✭
    edited 03/28/22 Answer ✓
    Options

    Sorry missed that part, try this

    =IF([W/O #]@row <> "", 60)

    Convert to column formula

  • VinceA
    VinceA ✭✭✭
    Options

    Did the trick ... thanks Paul.

    V_

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!