-
IF formula for earliest date
Hi Community, Could anyone please help with this formula syntax? I want to capture what is the earliest date within a date range for a specific role, "Production" in this case. =IF(Role:Role, "Production", COLLECT([Actual Start]:[Actual Start], [Actual Start]:[Actual Start], MIN([Actual Start]:[Actual Start])), "") It…
-
Need help with 'If , Then' function to subtract Duration Values
I'm setting up a Construction Schedule with Variance calculations as the 'Near Term' baseline solution that's been quoted as coming for a few years now has not materialized yet. Unfortunately after searching the forums I'm not seeing syntax examples that work for what I need to do. It would be helpful for me at least to…
-
How to link the health column to show an accurate status of at risk tasks.
Hi All, I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task. I want to aim for this to detect the percentage of completion of a task in relation to the finish date. For example, if the finish date is only a couple of days out and the…
-
I.T. Project Management workflow process
Hello, I am new to Smartsheet and have seen nearly all of the training videos, I work in I.T. Cybersecurity and wanted to get your opinion on how to create a Smartsheet(s) for looking at installation, failures, dates, etc. for I.T. disk drives. I have information on an excel sheet that was provided & an initial Smartsheet…
-
Smartsheet Form Multi Entry
Hi All, Just have a query regarding Smartsheet forms. I am currently setting up a form to track consumables for a project. The project may have up to 20/ 30 different consumables associated with it. Is it possible to use a multi-select dropdown for the user to enter these consumables which in turn will enter the required…
-
Is it possible to set up your own template sets?
Hello everyone! 👋 I've created a workspace for a project which includes multiple sheets, reports and dashboards which all link together. It's something I've put a good bit of work into for a while! Is it possible to use this as a template set for other projects? As far as I can see, I can only create a template from a…
-
SUMIF formula when cell contains multiple collaborators
I currently have a formula that will sum up the "Hours Used" from the "proposed hours needed" field based on which intern is assigned. =SUMIF(Intern:Intern, "Michelle", [Proposed Hours Needed]:[Proposed Hours Needed]) However, when BOTH interns are assigned, it doesn't acknowledge the hours - how can I update my formula to…
-
Auto-Populate Left Stub for Schedules
Thanks to Paul Newcome, I was able to get a WBS schedule working. Now I need to create several schedules, using the WBS as the left two columns. Here is the problem - I need for all schedules to update whenever a row is added or deleted from the original WBS sheet. Simply using Cell Linking does not achieve this. Here is…
-
Fail to reset passowrd because of no response to the challenge CAPTCHA
Hi, I am a business license user, recently, I shared the report to the people. some of them feedback, since we forget the password, when they tried to reset passowrd by click" forget password", they got the message “ the request can not be processed becuase it does not include a response to the challenge("CAPTCHA"). those…
-
Scheduling with Fixed Capacity Resources
I need to schedule project tasks by resource availability. All of the smartsheet resource management tools appears to assume there is always a resource available for the task, so the advice is simply to schedule another resource when one is overbooked. I actually view resource availability as a constraint. Specifically, I…
