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…
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…
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.…
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 s…
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…
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 priva…
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…
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 hav…
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…