-
COUNTIFS from multi-select drop down
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works great since it is automated once the @row are filled in by my Team: =COUNTIFS({Planning sheet Range 2}, PA@row, {Planning…
-
Version Control of Project Plans/Sheets?
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, so we need to amend it. Since there seems to be no way in Smartsheet to baseline the…
-
Has anyone attended the Project Management Track from the Learning Center
Are they worth the price tag? can I get this info watching Youtube videos for free?
-
Designate Holidays for Multiple Years
Hello, I am wondering if there is a way to automate/semi-automate adding holidays to project settings. For example, is there a way to indicate 12/25 will be a holiday regardless of the year, so that as time goes on new Sheets will always take into account standard holidays? Thank you, Dan
-
Index Match Formula with Multiple Criteria?
Hello, I'm trying to create an index that has multiple criteria. I'm not sure if I should do this using an "IF" formula, or if I need to incorporate the "AND" function into the formula. Or if I need to go in another direction to accomplish this. What I need to do is return the "Rate" based on the "Crew Type", and the…
-
Checkbox Formula for entire Column
I am currently using something similar to the below to translate checkboxes to values, and am then concatenating those values: =IF([Test 2]1 = 1, "Test 2:", " off ") The problem I am running into is as new rows are made, the formula is not auto-populating the cells. does anyone know how to incorporate the above example,…
-
Record a Date Action for Automated Workflows
I've noticed a few posts on Community re: the release of a new workflow action - Record a Date. I'm not (yet) a member of the "Social Groups" Community so I'm unable to read the full text of each post. In addition, a Smartsheet Partner @Debbie Sawyer made reference to the new workflow action in her answer to…
-
Percent Rollup Working Inconsistently
We are tracking Open Enrollment for several clients in two major categories - MED and FLEX - with tasks necessary for each. In the screenshot, the percentage for the client at the top is rolling up, but the the bottom is not. Is this because the first item has a duration of ZERO? I would still think marking it as 100%…
-
MAX Function Error (#INVALID COLUMN VALUE)
Hello, I am working on creating a project plan. Instead of having the singular Status Update field that comes with the project plan template, I wanted to keep a log of status updates, then reflect the most recent info from that log in my project plan. I created a new sheet/grid with 3 columns. Weekly Comment, (automatic)…
-
Day of Week instead of short date
Hello, I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the [Day] Column, and so forth... Is this possible?
