Possible to automate numbers per row type?
I am adding a PO system in our smartsheet that holds different types of financial tracking. I want to auto populate new PO numbers, however, only for a row if a different column is marked as "PO Request." Is this possible? Currently the autonumbering feature does all rows.
I've tried the following column formula so that if there are other types, it will show "n/a", then I change the column type to automated numbers and it only counts rows that are blank (which is what I want!). But this only happens if information is already in the sheet. If new submissions are made, then the autonumbering column overrides the formula/function below and every new row after that starts autonumbering. Thoughts? Would there be an automation that could add a number only for specific rows marked as PO? Or a hidden question the submission form that could create numbers when a new submission comes in?
=(IF([Payment Type]@row = "Invoice", "n/a") + IF([Payment Type]@row = "Independent Contractor Work Hours", "n/a") + IF([Payment Type]@row = "Employee Reimbursement", "n/a") + IF([Payment Type]@row = "Constituent Refund", "n/a") + IF([Payment Type]@row = "Employee Credit Card Receipt", "n/a"))
Help Article Resources
Check out the Formula Handbook template!