-
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…
-
Is there a way to have completed tasks within a sheet, move to a parent row called "complete"
I am trying to see if there is a way to move completed tasks within a sheet so that they are not in the way. Maybe having them move to a parent row that is collapsed called "complete" so that they have open it up to view the tasks, but they are still out of the way. I would like for this to be automatic. Thank you!
-
finding average risk score
Hello, I am trying to find the average risk score across multiple sheets given the criteria of being a risk and being open. I am trying to use an (AVG(COLLECT( but I am getting an invalid operation. Here is what I am trying: =AVG((COLLECT({CA Risk Score}, {CA ROI Option}, "Risk", {CA Risk Status}, "Open") + COLLECT({CRV…
-
How do I create a function formula for my query?
I want to create a query that sources another datasheet that contains multiple certification types, certification numbers, roles, and ID data where you can type in the employee's name and all of the information will populate on the Query sheet. What function formula would work best with this?
-
COUNTIF is a reference to another sheet or is a link
I need help to count if a cell contains any link or any reference to another smartsheet. Not a specific file, but any file. Thanks!
-
Assistance with Averageif formula
Hello, The formula below was working great until I was asked to add a new requirment where I need to exclude values that are greater than 14 . Otherwise the average is incorrect if greater then 14 "cells" are included. I tried the Averageifs but got lost trying to figure it out so here is my original formulas sans the new…
-
How can I write a formula to pull data based on dynamic columns?
Hi all, I'm trying to write a formula that will pull row information based on dynamic Columns. My goal is to understand the difference in hours worked between last week and the week before. I would like to be able to flag if a Person has not updated hours in a week. I have a 'raw data' sheet which has team member names in…