I am trying to develop a function for a cell to produce a unique ID only if another cell is blank. Some of our assets has predetermined IDs and some need ones assigned, which I am hoping we can automate. Any suggestions?
In that case you would need 3 columns. One that generates the default (auto-number column or formula), one that allows manual entry, and then the third would show the desired ID using an IF statement along the lines of
=IF([Manual ID]@row <> "", [Manual ID]@row, [Default ID]@row)
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Are you able to provide a screenshot for reference?
Sure! So, I want anything that has a blank cell in the StockID column to populate an auto-generated ID. I attached a picture of what I am thinking. @Paul Newcome
Thank you! That worked perfectly.
Happy to help. 👍️
@Paul Newcome I have another question along the same lines!
So, I have a fourth column that, if 'reused' is selected, it will leave the auto-generated ID cell blank in an auto-generated ID column. Is this possible? The initial setup is above, which I still need, plus this new function I am asking about.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
©2024. All Rights Reserved Smartsheet Inc.