-
How to return specific text in a cell if another cell is blank
I have one column containing "Publication Date" and another containing "Next Review". How do I create a formula to populate the "Next Review" with a value of "N/A" if there is no value in the corresponding "Publication Date" column?
-
Risk Rating Formula
Hi all - I am trying to create a long formula and need some assistance. For a Risk tracker I have 2 columns (Probability and Impact) both which have list values of High, Medium, Low. Based on those selections I want to have a 3rd column which is the output of the formula, Rating, designated High, Medium, Low. Below are the…
-
Probelm with IF(Contains formula
So I have a sheet where different fellows enter their budget through a form. I am trying to copy the budget from a certain fellow in the T&E Descritionary column on the basis of the submitter's BIN Number. The formula I am using is =IF(CONTAINS("507777", [Employee BIN]@row), [Fellow 2 $ Share]@row, IF(CONTAINS("507753",…
-
I am looking for a round about way to create a search function in SmartSheet.
I am trying to create a formula to use on a 'Search Sheet' that, when a keyword is entered into a cell, it will return several columns of information from potentially more than one row of the source sheet. I have done so much research that I think it may involve Index, Match, Collect, and maybe some other functions.…
-
Getting the wrong output from IF status formula
Hello Smartsheet World, I am trying to fix a formula to give me the most recent status given in a collection of columns. for some reason the last column is showing as Approved even though it is labeled Pending review. the rest of the formula works as needed. The formula is as follows: =IF([Level 4 Approval]@row <> "",…
-
Checkbox Used as Input in Dashboard
Has anyone ever used a checkbox input from a dashboard in a formula to include/exclude certain data in a calculation for the dashboard? I currently have a dashboard where I ask the user to input a date range that would be used to parse all of the data that could be shown in a dashboard to only the data in a date range.…
-
Required advice on creating a view on Overdue tasks
Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?
-
IF Function / Formula Help
I have created a budget sheet template and need to add seasonlisation to identify cross-charges by month. Rather than doing this manually every time, I would like to add a formula that pulls the data from another cell, but based on information in a 3rd cell. I was hoping it would be as simplistic as: =IF([Activity Month]3)…
-
Is there a way to show employees who can cover a shift based on meeting the credentials?
I have employees who submit a request if they need time off. We have all of their credentials listed in a separate sheet (ex: employees have licenses in certain states). Is there some sort of tool or resource or formula that when someone submits time off request, we can easily see the people who can cover rather than going…
-
Automated Workflows to retrigger after decline
Hi Team, The Requestor/ initiator is not someone who would have access to the SS tracker. The person would simply update the required fields and submit the form for next step of approvals. I have build the form for 4 approvals levels and it works fine when each level just hit APPROVE and not decline. However, if one hits…
