-
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…
-
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!
-
Sequence numbering based on another Cells info.
I'm looking for a formula to sequence document numbers based on another cells info. I've set up IF functions to code each main column (in blue) which will be hidden in the background & locked to which i then used a JOIN function to get a serial code. (shown in "document Code"). With those in place, On "Document No." Column…
-
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!
