-
COUNTIF with multiple select dropdown column
Hi, This has me going mad! 🤬🤣 I have a sheet reference "Business Area" which has a column type of dropdown multi-select. I'm then using a COUNTIF on specific values to compile a metric sheet. This is counting fine where the dropdown has "C" and "E" selected: =COUNTIF({Business Area}, @cell = "C" + CHAR(10) + "E") However,…
-
Multiple IFs combined with Countm formula
Greetings, I'm currently attempting to write a formula to provide variable outputs based on a Countm function(column in my smartsheet that has multiple dropdown options). What I'm looking to do is have a single formula that will take the result of a Countm on my "corporate objectives" and output a percentage. In the…
-
Calculating Schedule Health - RYBG
Hello, I am a beginner Smartsheet user and I have listed my set of requirement to track my schedule health task. The requirements are based off % Complete and % Time Elapsed. Requirements below: Tasks that show status of “Complete” - Blue Status in progress, where the % Complete is greater than or equal to Time elapsed. -…
-
How do you link certain information from a form to a sheet or report?
I am trying to link certain information from a form to another sheet. The form is a questionnaire with a Likert scale from 1-5. If the user select a 1 or 2, they are required to put in a comment. The comment is another question which shows as a column on the sheet. And lastly, the user who is filling out the form will…
-
Data Migration/ Data Shuttle between 2 sheets
I have 2 sheets Sheet 1: Projects pending approval Sheet 2: All the projects that have been approved I want to build functionality where when I check an approved box in Sheet 1, it will automatically push to Sheet 2. There are a couple issues/ complexities. One of the biggest issue is that the Sheets have different column…
-
Adding Days to a Date Based on a Condition
Hi I've trawled the forum for previous questions but can't seem to see one similar to what I need. I have a date column that I want to auto calculate based on a condition within another column. If [Corrective actions to be completed] = "Immediate" or "5 working days", take [Corrective action chaser 1] + 11 days, if…
-
formula for +40 days after Q
hello, thank you in advance i am looking for a formula to auto calculate 40 calendar days after end of quarter. which does not include holidays or weekends. thoughts? Thank u
-
Dropping day from date format
Hi Smartsheet Community, I need to report a date field in a report, however the client only wants to report mm-yyyy instead of the full date (dd-mm-yy). For example, in the fields below they want to report 09/2020 and 04/2021, and 08/2020 and 08/2020 respectively Is there anyway to drop the day component in another column…
-
Populate Q1, Q2, etc with IF function not working
Hi there, I currently have a formula that is working for Q1 & Q2, but for some reason, it is not working for Q3 & Q4. I am at a loss as to why this is not working properly. Any ideas? =IF(MONTH([End Training Date]@row) < 4, "Q1", IF(MONTH([End Training Date]@row) < 7, "Q2", IF(MONTH([End Training Date]@row), 10 <"Q3",…
-
Multiple users in dropdown formula
I'm trying to countifs a user is on target. My sheet column is a multiple selection column, some rows have multiple users selected. When I create my formula, it doesn't count if said user is sharing a responsibility with someone else. Here is my current formula =COUNTIFS({2021-2022 COMPLIANCE WORK PLAN Person Responsible},…