-
Workarounds for Smartsheet's lack of support for effort driven tasks?
I know that users have been clamoring for this shortcoming (the lack of support for effort driven tasks) to be addressed since 2015, but this is the first time that it's been a must-have for one of my clients since I began using Smartsheet in 2013. Here’s an attempt to describe what I need to accomplish: My client's team…
-
Non Human Resources
Hello Everyone, Can Smartsheets manage not human resources? In my case I am more interested in managing machines that people/ Cheers Kurt
-
Nested IF, AND, OR/AND
Hi all, New user here. I have different monthly metrics to comply, some are greater than or lower than a value or percentage (i.e. Open tickets beyond due date is LOWER than 10%, Survey results are higher than 70%, Safety observations over 30). I created a column [MEASUREMENT] stating "Higher than" or "Lower than", a…
-
Setting up Alerts
We are running a number of different projects on a sheet that have a: 1) - Delivery Deadline (which is specified by the client), 2) - Delivery Date (which is set by dependencies on our Production Schedule) When Production is running late, the Delivery Date can end up later than the deadline. How can we set up an alert to…
-
Extracting Numbers from a Cell Containing Both Text & Numbers
Hi All - I am uploading a .csv file into a Smartsheet sheet. One of the columns within the .csv file is formatted to contain '$ prior to the numbers within the cell (so when opening in Excel, it will not convert the cell contents into scientific notation). I need to remove the '$ text from the cell, so I can sum the value…
-
Cell Link Capacity
Hello, For 2019, is there any chance of the cell link capacities increasing? Does anyone have any insight to this?
-
Report Not Updating
I have several reports setup to filter a sheet by status and up until today everything worked fine. Now, when the status changes, the report doesn't get updated and I don't understand why. For example one of the reports filters for a status of "Design" and when I perform the necessary steps to move it out of the "Design"…
-
COUNTIF where cell contains checkmark EXAMPLE
Need a 'countif' example, where cell contains a checkmark?
-
Automating Update Requests
Having read many posts on the subject, I am guessing there isn't a good answer, but I figured I would try anyway: I am trying set up a recurring task list for process checks in our plant. Every day, each contact has a number of checks to do. I have figured out how to set everything up so that the update requests go out…
-
Calculating a staged reduction in severity
I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then have that drive an auto-calculation of the final score of the Risk. Unfortunately I am…