-
Automation problem
Hi, I'm having issues trying to get my automation to function. I have tried it numerous ways and it still doesn't work. Basically, if anything but New York is selected, I want a link email to go out with an additional form I need to fill out. Here is what my workflow looks like: I just cannot figure out what I'm missing…
-
Help to link health status formula to status
Hi, Need some help here is my current formula for health status in project plan. =IF([End Date]@row = "", "", IF([Summary Helper]@row = 1, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", ""))), IF(Status@row = "Complete", "Blue",…
-
Welcome to the ENGAGE Guestbook: Share & Enter to Win!
Hey there, ENGAGE attendees! We hope you're having the best time at the conference. We'd love for you to take a moment to sign our virtual ENGAGE guestbook. 😉 This gives you a chance to win one of the cool gift baskets, filled with Smartsheet swag and products from local businesses. Want one? Participate by telling us:…
-
Projects releasing today + 60 days
Hi all, I have a formula such: =COUNTIF({project rel +2mos}, >=TODAY(+60)) that is returning a 0 count, even though there should be a count there. I do have the specified column I'm calling set to "Date". Any help greatly appreciated!
-
Request to be able to turn off default of 100% allocation
This new functionality will not work for us and will cause us to have to update every row: "Starting at the end of August 2024, new rows added with astart date, end date, and contact field in sheets connected to ResourceManagement by Smartsheet or with workload tracking enabled will automatically default to a 100%…
-
Merged: Enable Automation to Add Comments to Rows or Cells
This discussion has been merged.
-
Merged: Add New Comment as a Workflow Action
This discussion has been merged.
-
Changing Seat Type to Guest
This new model is completely confusing and sneaky. I gave access to external folks as admins because that's still a choice you can make at the workspace or sheet level. Now they're listed as viewers in the admin center, so they can't actually do anything with the sheets I need them to be able to collaborate on. I read that…
-
Is there a way to proactively include the three baseline columns in blueprint within Control Center?
The challenge I'm facing is that these columns aren’t created until the baseline is saved on the sheet—after it's already provisioned via SCC. I’d like to add them to the blueprint template sheet ahead of time so they can be incorporated into my profile data and made available for reporting. How can I do that?
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if the…