-
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…
-
Sum of work log between a date range for given list of users
Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all users. I tried summits but not able to come up with anything as it is always giving mw wither 0 or invalid argument. I tried…
-
Capturing multiple statuses, reminders for recurring tasks, form
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…
-
Calculating a percent
Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized. Any suggestions are appreciated. Thank so much, Katye
-
Set a conditional formatting across the entire sheet that only affects the cell where the condition
I'm trying to find a way to do what I've done with spreadsheets before, but I am not seeing a way to do in Smartsheets. In some of my fields, there are instances where I won't have a value. I populate those with NA, and I'd like to turn the fill for those boxes gray automatically. Traditionally I'd do a conditional format…