MAX/IF +1 Formula



I have a sheet for our job lists, we have 3 different types of jobs, i am trying to write a formula that will pick the next highest number in each of the sections

My work flow, is chose "type of job" and that will generate 1,3 or 5 in "job classification", i am looking to pre populate the Job# with the next highest

Let me know if this doesn't make sense. Cheers!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!