-
IfError returns "incorrect argument"
Hi, I am trying to find values that exist between two Smartsheets. When it does, I should get a checkbox, and when it doesn't, I would like the checkbox to be unchecked. If I use: =IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0) I get "#No Match" when a value…
-
Can you have a column formula in a column that has a drop down list?
Hi Everyone, My dropdown list is not giving me the option to make a selection now that I have a If formula in it. Column 1 = Team (this is a drop down list with the following teams: Career Development, Instructional Design, Learning Solutions, Leadership Development, Talent and Learning Ops & Infrastructure) Column 2 = LDO…
-
How to only Sum values for unique requests with a specific request type
Hello, I have created a sheet to calculate some data points based off of an archive of requests that get pulled from an Automation when Estimated Completion Date and Actual Completion Date are changed, and I am trying to setup a columns to display the Average Days to Completion for each request type to help with estimates…
-
Conditional Formatting - Dates in the past
Hi, I want to add a conditional format on a column holding dates that will highlight those dates which are over three years ago. I thought I would be able to pick "is not in the last (days)" and enter 1095, however it only shows "is in the last (days)" For now I have had to add two conditions: "is in the past" AND "is less…
-
Using a column formula to populate child rows without changing data in parent row of same column
I have a sheet where I am tracking meeting engagements with stakeholders. The Parent Row data is all manually entered and I want the data to autopopulate the children rows of some of the columns (e.g., Sector). I'd like to have a column formula that does this without affecting the data in the parent rows. I have my parent…
-
Grading Test Auomatically
Could someone please provide me some guidance on how to create an SS that, if the form is completed, the SS can grade an exam automatically? I work with General Residents that are going to be future surgeons. They have to complete a 5 hour lecture every week. Our departments faculty is obligated to join them due to having…
-
If Then Date
Good afternoon Smartsheet community. I am trying to get an if/then function to output a date in my sheet. I have a few columns I am checking against and feel like I am close but need some help getting it to work properly. Here is my formula: =if(AND([Project Type]@row = "N Type"([3. RWA Acceptance Date (PM/Kayla)]@row =…
-
IF THEN use for equations/calculations
Does the IF THEN function work for this scenario? IF the number in that cell is negative THEN use this calculation, IF the number is positive, THEN use this other calculation Note: Sorry, due to privacy issues, I cannot share the actual calculations.
-
Record a date for previous check box
I want to record a date for when the check box is true. I know I can set up and automation but I want to see the dates of previous check box.
-
Help with Summary report build using matching dates to sum meeting minutes used.
Good morning! I am trying to build a meeting report for my team's weekly Work In Progress (WIP) meeting. I am using a form for team members to fill out how much time they need for our one hour meeting and on which date. I have a formula that takes any matching [WIP Dates] and sums their [Time needed in minutes] The Sum of…
