-
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…
-
Cancel Scheduled Backup
Does anybody know how to cancel scheduled backups?
-
Formula to determine the date that another cell was updated
Hello, Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date. =IF([Status]1 = "Completed", TODAY()) Thanks for your help! Andrea
-
Automatic Cell Highlighting
I am logging man hours for construction jobs. I have three columns that perform this function. One column for "Budgeted Hours", one for "Actual Hours" and one for "Remaining Hours". I input hours into the "Actual Hours" column daily and it updates the "Remaining Hours" column automatically. I want to set up a formula that…
