-
Report with multiple tasks as ("what") conditions
How do I create a report with multiple tasks (in my primary column) as conditions? E.g. I wanted to display sheets in a report where Task 3 = Yes AND Task 5 = No.
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Current Task Formula based off certain criteria (symbols)
Hi, I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. Attachment for context --> I would want the formula to read all of those tasks and…
-
Automatically repeat rows within a schedule (daily, weekly, monthly etc)
Hi, We use schedules to track publication output. Is there a way, when a form is completed or when a user adds to the schedule, an option can be selected to repeat the entry either daily, weekly, or monthly? Thanks, Dan
-
Cancel Scheduled Backup
Does anybody know how to cancel scheduled backups?
-
Reporting from multiple sheets into a single resulted row
Is there a way to run a report that looks at 2-n sheets that uses a common column (primary key like), like a Row ID, to import the data from several sheets into a single row of the report?
-
Capturing multiple statuses, reminders for recurring tasks, form
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…
-
Contact Columns marked Multiple Don't Populate Legacy Reports
I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I noticed that Reports count those columns as different than other Assigned To columns without this feature enabled even though…
-
Two Columns Named 'Assigned To'
Hello. I have a report that pulls milestones from multiple project plans. I created this report from a template within Smartsheet. There are two columns named 'Assigned To' Can you provide any answers as to why they seem to be duplicated and pulling information differently? Note that I have multiple shared project plans as…
-
Issue with Dashboard/Report
The "Current User" sees no rows in a Dashboard Report. However, when he clicks on that report in the Dashboard (the underlying report comes up through the EDIT INTERACTION" feature) the user is able to see all rows there. What am I doing wrong here?