-
Rescheduling Remaining Work
If you are familiar with MS Project, you are aware of the Reschedule Remaining Work functionality. Does this type of feature exist in Smartsheet? If not, what is used to "push" out work not completed to determine the new end date?
-
Adding multiple columns at once
Hello, Based on a previous post I saw in regards to rows, I wouldn't be surprised if multiple columns cannot be added unless done one at a time, however if it is possible can someone please assist? I would like to add about 5 columns at the same time without having to add them individual and name each one at a time. Thank…
-
Overdue Calculation with Conditions
Hello, I have a "Due Date" column and a "Complete" column. I want to create an overdue days column. If 1) the complete column has not been checked, and 2) today's date is past the due date, then I want the overdue days column to calculate the number of days (net days and not work days) past the due date. I've looked at…
-
how to hide columns for certain users
How do i hide certain columns from users.
-
Sorting by RYG balls
Hello, in help (https://help.smartsheet.com/articles/504742-sorting-rows) I found that when I'm sorting colors in ascending order the blank rows will be on the top. But when I sort it descending or ascending the blank fields are always on the bottom. What am I doing wrong?
-
Report Builder - What section
Hi, I'm trying to number actions on my list as 1.1, 1.2 etc, all relating to a section 1 in my smartsheet. I also have a handful of actions that I need to number as 1.6a and 1.6b etc. When creating the Report Builder however, the 'What' section doesn't seem to handle the letter, only the number, therefore any rows that…
-
Reports: Sorting groups of rows by the end dates of their respective master rows
Hello! I am hopeful that I can find the solution to this issue. This is a bit of a long one, so get comfortable! I am using SS to organize the workflow of active jobs at our precision manufacturing facility. Each job requires almost 100 independent job steps from start to finish. Each individual job task is on a separate…
-
Conditional Formatting Not Working for new rule
Hi, I've tried to change my conditional formatting rule to grey out "cancelled" status items yet it seems stuck on the old rule. Furthermore, I don't seem to be able to do anything else with it. I've never had issues with these rules before. Screenshot is attached. Any ideas?
-
COUNTIFS with ranges
Hi, I have a task list with a flag column and collaborators in 5 columns, so a collaborator could be the primary responsible or up to a 5th level involved in a task. I haven't been able to use Countifs function in a formula which will retrieve from the list how many tasks a given worker is involved into, the function works…
-
Meeting/Projects in an academic environment
Hi, I'm chair of subcommittee that reports to the curriculum committee. My subc has monthly meetings, for which I need an agenda, minutes, and materials for the members to access and edit. A large part of our work is reviewing each required course in our curriculum (and there's a process for preparing materials and…
