-
RYG ball based on due dates
I already have a formula created that automates the RYG ball based on due dates... =IF(Complete1 = 1, "Gray", IF([Due Date]1 < TODAY(+3), "Red", IF(AND([Due Date]1 >= TODAY(+3), [Due Date]1 < TODAY(+7)), "Yellow", IF([Due Date]1 >= TODAY(+7), "Green", "Nope")))) What im having an issue with is whenever the cell in the due…
-
New Format is less efficient--More Clicks to manage our work!
The new format that was introduced today is definitely not more efficient! In fact it's creating more work through extra clicks.
-
Changing actual start date - Predecessors delete
Hi, I wonder if someone can assist me. I am running schedules for construction projects with predecessors (Finish-Start relationships) set up. If myself/or another employee change the actual start date of a line item then it deletes the predecessors. I know that to avoid that from happening - You must either change the…
-
RISK - Projects
Does anyone use Smartsheet for Risk Assessments / Risk Management? If so, What template do you use and what is your process? I've found on the link below several templates for Risk Management. However; when I download the excel and import it into smartsheet, the functionality is lost.…
-
Print Card View?
Is there a way to print card view, or even share a link of it to a non-SS user? Love the flexibility it's given me to sort in new ways, but can't figure out how to share it with anyone else.
-
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…
-
Translating Date Formats
We have Smartsheet integrated with another system and pulling data across into Smartsheet. Currently the date format that is coming across is (YYYY-MM-DD) and I want to translate that into my local profile date format of (MM/DD/YY). Is there a function or formula that allows me to do this? I have been unsuccessful in my…
-
Count number of specific characters in a string
Hi! I'm trying to write a formula that will give me the level of an item in a Work Breakdown Structure (WBS). The formula needs to read the number of decimals in a string. For example: * 1 = 1 * 2.12 = 2 * 3.1.14 = 3 * 2.1.1.1 = 4 * 2.327.1 = 3 The FIND function seems to be heading down the right track (by selecting the…
-
Government Utility Projects and Asset Records
Hello Smartsheet Community, I work for the City of Minneapolis, in Minnesota, and I’m looking to reach out to see who is working for governments (local, county, state, or federal) while incorporating Smartsheet into their utility project management processes. Smartsheet is restricted from its privacy policy to release any…
-
Slack notifications with more context.
Hi, I have just set up my sheet to send slack notifications whenever the status of a task is changed. So for example I have two columns, one is for tasks and the other is status (of the tasks). So an example would be: "World domination" I "In Progress" Now say I conqure planet earth and want to move on to building my evil…
