-
How can I set a column to automatically select Yes or No based on other column criteria
If Submitted SC Form is Yes and Completed Training is Completed and SC Mailbox Status is Active than I need Completed All 3 Actions to select Yes, otherwise No if any of the three criteria are not met.
-
Counts of statuses across multiple sheets
I have several sheets in a workspace which track specific tasks. Each of the sheets has the same columns and formatting. I want to be able to show on a dashbord the count, by status, of each of the columns where the status is being tracked. What is the best way to do this?
-
Vlookup a cell with a formula
Hello everyone, I am trying to use a normal Vlookup function in smartsheet. The search_value (number) and also the value that is supposed to be looked up in the look_up table (same number) are also pulled with other formulas. If I hardcode the numbers instead of suing a formula, then the Vlookup works. Does this mean that…
-
Formula Breakdown
Hi! I got the health status formula below from a WBS template I found on a Smartsheet community thread (I can't find the link to the template but will continue to look). Anyways, can someone break the formula down into layman terms of what it's saying? =IFERROR((IF(OR(Start@row = "", Start@row > TODAY()), "Blue", IF(OR([%…
-
Pulling from Multi-Select to populate under appropriate line in another sheet
Hello, I am using the attached formula to try and ensure that I can expand the formula (currently has a 1:1 from a Project plan with RACI into a RACI Matrix with tasks associated to users) so that rather than creating a duplicate row for every person responsible (from a group) I wanted to change it to a multi select and…
-
Using "Contains" or Wildcard to search for duplicates
I am currently using COUNTIFS to find and flag duplicate persons by a match of both last and first name with this formula: =IF([Last Name]@row <> "", IF(COUNTIFS([Last Name]:[Last Name], =[Last Name]@row, [First Name]:[First Name], =[First Name]@row) > 1, 1), false) I want to change it so that it flags fields containing…
-
How to match collect an list based on role
I have a sheet one column is role which has for example Project Managers, Network Engineers, Database Engineers performing tasks throughout the sheet. I have a start and end column for each task - I want to collect the start and end date based on role - what is the earliest date, latest date for each role.
-
If Contains Specific Year Formula
Hi, I'm trying to use a formula that will look at a date column to populate another column. If year in that date column is 2022 I want the new column to say Not applicable, but my formula is not working. =IF(CONTAINS(YEAR(2022), [First Receive]@row), "Not Applicable", "") but it's giving me an invalid data type error
-
CountIfs question
I am trying to write a formula that Counts the Active projects for Q1. I have a column titled Quarter and each quarter is labeled Q1, Q2, etc. My formula says =Countifs({(Sheet name Range 1)=Q1)} and I'm getting an #Unparseable error. Any suggestions?
-
Today Formula
I have a #blocked statement in the cell that shows the Today formula =Today (). The cell exists to show today's date and then use it for other formulas. I'm not sure how to proceed.