Trending in Formulas and Functions
-
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
-
I need the Form to populate information to different sheets in Smartsheet
Hello Smartsheet community, Could you please advice, I need the Form to populate information to different sheets in Smartsheet depending on the dropdown menu choice. For example, there is a new project enquiry form, depending on the department choice information should be populated to the appropriate department's sheet. I…
-
How do I override a cell that is set to Auto Number?
I have two sheets with an auto number column named "Work ID". The rows from one sheet get moved over to the other, and then the new sheet adds children to that row. I need to keep the column set to Auto Number in the second sheet in order to be able to move from the first, but I don't actually want to use the Auto Number…