I have a Vlookup function in one column and I have it set up to return information when certain criteria is met by selecting information from an adjacent cell. If no selection is made in the adjacent cell or in the rest of the row, my auto-numbering column still populates a number even though the
I have a due date column that was manually put in shown below. Next to it is how often the task needs to be done. Is there any way to set up an automatic formula that will create a new due date after the current one has passed, or will I always have to go in and manually change the due date for each
Recently we updated some of our reports with the new automation. However, only two colors (green and red) are populating in that automated email. We have yellow and blue that are not showing. Can anyone assist? Are we doing something wrong?
...without entering a value in a particular cell? For instance, I want to make sure that users enter a ZIP CODE is a row - If they do not, I would an error/warning to pop up or, at least, inability to save the entry without entering the ZIP.
Is there anything similar to a pivot table capability in excel? I am trying to graph and analyze text - not numeric values. I figure I can make a secondary sheet in which I can do the formulas I need but I was trying to figure out a way to do this with minimal
I have an Auto-Number function running in one column and after number 1966, I added information in the next row, and it spit out the number 1997. I then deleted the information in the row and then added it again and now its 1998. I added another row after and its 1999. I need the next row to be
Hello, and many thanks in advance for your help. I'm new to Smartsheet and spent some time looking through the various answers on this community forum and could not figure out the answer to this question.
I've attached a screenshot of a smartsheet I've made. I added a section at the bottom of my
I believe this is an enhancement request but I see it is always good here to start the conversation in the community to test the appetite before requesting it, and it seems it gets picked up by staff more here.
I am creating project templates in smartsheets for our project managers. I am doing this