-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
index match using multiple critieria
Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different ) The formula Im using gets me an INVALID…
-
IF formula with multiple conditions
Hi! I am trying to create a risk register template and would like to have the columns: 'Impact', 'Likelihood', and 'Risk Score'. The Impact and Likelihood columns will be user selected input from a drop down menu, where the options are 'Low', 'Medium', and 'High'. I would like the 'Risk Score' column to then populate based…
-
Changes over Time - COUNTIFS?
I have a project where a group of users can submit a smartsheet form at any time to request a new enhancement to one or more of 3 tools. One of these tools is managed by an outside vendor and therefore management wants to be able to track number of enhancements submitted to them as well as how they progress through status…
-
How can I use Conditional Formatting for date in the past or future when a formula created the date
Hi Everyone, Thank you for your time in reading this. How can I use Conditional Formatting for date in the past or future when a formula created the date? The black columns are different dates generated. The 2 yellow columns are then selecting the relevant date based on different criteria. The white columns are me trying…
-
Is anyone experiencing issues with Completion % not accurately rolling up to the parent row?
We use a change cell value automation to update the standard % Complete column to 100% when a task status changes to Completed. This used to work perfectly, however, recently we noticed that the % Complete for the parent row in our project plan (e.g., Planning, Execution, Closing) is not recognizing the cell update. Our…
-
Automatically HyperLink URL that's pasted into a form
Hi Smartsheet community. I am trying to figure out how to directly link a URL (pasted into a form !!) to a cell with the exact same hyperlink click-word for that link type. Let me explain the situation better: My company has a sort-of project database spreadsheet to keep track of "leads" or projects that could progress…
-
formula for raid log
I would like a formula that if a user selects risk in the type column and enters the risk information.. and later on in the project this risk becomes an issue.. the formula will auto score the likelihood column to default to 5. Can anyone help with this please?
-
Auto Check a box after 24 hours
I have tried to get smartsheet to auto check a box 24 hours after a row is created and column "Task Started" is not checked. =IF(AND([Task Started]@row <> 1, TODAY() - Created@row >= 1), 1) This returns #UNPARSEABLE. Any help would be appreciated.
-
Cross sheet ref to find who's elligible for a job based on credentials
I give up - I need help with a seemingly easy formula pls. I have the 2 sheets below - One is list of crew and their credentials. Other is a list of Jobs and the Required Credentials to work each job. The formula I used in the 'who is elligible' column is only listing exact matches. (Bob can work the Ace job because it has…
-
Pause "Days in Progress" counter
Within our SS solution we have a formula that starts a day counter from project status of "assigned" and stops counting when the project status is marked "complete". So if a project was assigned on the 5th day of a month and the project is marked complete on the 10th, it captures that the project was worked on for 5 days.…