Sheet ID as value in Cell

Is there a formula (or some other method) of automatically having Smartsheet input the Sheet ID into one of the cells on the sheet?

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Ramsay Zaki

    If you're looking for a way to automatically extract the sheetID into a cell without having to manually determine it first, no, there currently isn't a way.

    If you're looking for a way to add the sheetID into a field after you had looked up the sheet ID from the File properties File>Properties>SheetID, you could add the sheetID to a helper column field using an IF formula

    =IF([Primary column]@row<>"", sheetID)

    making sure to change the [Primary column] name to your actual column name and the sheetID to your actual sheetID. Alternatively, you could substitute any of the system-generated fields instead of the [primary column]

    Would this work for you?

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!