Sheet ID as value in Cell

Ramsay Zaki

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

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