Is it possible to have several autonumber cells in the same row shich are automatically filled in when another checkbox in the same row is checked? I need up to 6.
Are you able to provide a screenshot with some sample data for context?
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
I need to have an autonumber in "registro" column only when "MUESTRA 1" si checked.
I have 6 "muestra" columns and 6 "registro" columns per row, not necesarily filled in, though.
Unfortunately that is not possible. An auto-numbered column is always auto-numbered. It cannot be conditional. You could write a formula that would conditionally auto-number the column, but that would be quite complex.
Each of your 6 columns would need separate formulas to write the values to the rows based on your checkbox criteria.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
©2024. All Rights Reserved Smartsheet Inc.