I know I can do this with a helper column, but I'm trying to avoid that since this sheet copies to a bunch of others and I don't want to have to go and hide the column in all of the downstream sheets. I have a ID column that consists of alpha and numeric (ex. ENV-032) in sheet A. When someone fills out a form to add a new…
I work for a large telecom company in the Environmental, Social & Governance team as a member of the Data Governance team. I'm currently based out of Alpharetta, GA, but will hopefully moving back to the Philadelphia area soon. I started using Smartsheet in August 2022 and mostly use it as a workflow management tool to…
I would like the auto number field to always be calculated whether a new row is added directly or copied/moved from another sheet. With current functionality, if a row is copied/moved from another sheet, and that sheet has a Auto Number column, the value from the original sheet populates the new sheet. This would be in…
我有两个列s Value and Units that individuals are filling out. Some rows will have percentages for the Value and others will have numbers. I have third column Current Value that combines Value and Units, but when someone enters a percentage Example: Value = 15.25% Unit = "women in Group A" Current Value Formula =…
