-
Can I filter or sort by highlighted changes?
I have a project tracker sheet that is set up so that we can import a file from our customer regularly that updates existing worksites, and adds new ones to our tracker sheet. We are able to use "Highlight changes" to easily see what cells are updated and what rows are added. What we would like to be able to do, either in…
-
IT PMO Template Instructions
I'm new to Smartsheet and need assistance with using templates. I didn't see instructions on how to use the IT PMO template, but I like the functionality and want to use existing projects to add to the template as well as create new projects from the Intake process. Would love a guide or even one on one support engagement.
-
How can I change this Formula to leave the cell blank rather than #INVALID DATE?
Most of the other columns in my sheet only require the counting of days from a date in a different column. When the source column in the formula is not filled out the cell is blank. I am guessing it has something to do with it starting as "IFERROR". EXAMPLE OF A FORMULA THAT WORKS: =IFERROR(WORKDAY([Bldg Initial…
-
Workaround for triggering generate document workflow when any of the 380 fields I have change
I need a generate document workflow to run anytime one of them changes. I don't want to put in all 380 fields, I don't even know if it will let me add that many. It seem as if the "if any field changes" option is not available on the generate documents workflow, you have to select at least one field.
-
How can I create a Task/ To-Do List for each team member?
Hello, Looking to develop a task list for team members from our Project Tracker. Our sheet runs left to right and uses Column Headers to organize information rather than using Parent/Child row hierarchy. Currently, each step of the project has an expected completed date (automated by formula), an actual date column…
-
Create a report of all Rows that have images attached
Hi, I'd like to create a report including the images that are attached to every row, to visually see a list of issues that are being tracked. It seems like quite a basic feature that many people have asked for, but I can't see how to do it. Thanks
-
IS THERE A WAY TO GROUP PER WEEK?
I am trying to group per week on a report so like it would say " week of mm/dd/yy - mm/dd/yy" or just "mm/dd/yy = mm/dd/yy"
-
What does "Please update my online sheet" mean?
Hi, I have a master Smartsheet that gets input from several "feeder" sheets. Occasionally I get a message with a subject line that reads "Update request for XYZ Marketing Intake: Alert: ABC received - to first review team". The body copy says "Please update my online sheet". I have no idea where it's coming from or what it…
-
Need a form to send employees for availability
I'm having trouble creating a form that we we will send all 6 employees that will display all our new upcoming events and they can choose which ones they can attend. When I send the form to employee #1, I don't want the other employees to see what they have chosen. I do need their results to automatically come into the…
-
Large Sheet Notifications
We have a handful of very intricate, detailed, and logic-filled intake forms that are tracked in 3 separate master sheets separated by the type of intake. Each sheet is over 150 columns wide. We need to send a copy of the entire submission to the person who submitted it, along with several others selected in contact fields…
