Is there a formula (or some other method) of automatically having Smartsheet input the Sheet ID into one of the cells on the sheet?
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?
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…
On my Smartsheet, I want to count the number of lots manufactured per year based on the date of manufacture. If the date is between 1/1/2023 and 12/31/2023, give me a value of "2023", and the same moving forward in 2024 and so on. I cannot figure out what the formula will be. Can someone please advise? Thank you in advance.
I'm looking to put together a formula that outputs a status based on a few criteria. This formula should output "Denied" by default. If the [Price] is $500 or less and [ManagerApproval] = "Approved", output "Confirmed". If the [Price] is more than $500 but less than $1000 and [ManagerApproval] = "Approved and…
©2024. All Rights Reserved Smartsheet Inc.