Hello! I'm in need of some help with something that seems so simple but I'm going in circles. I was using a form / sheet to track responses for a program that runs quarterly. Standing up a new form / …
I have a project type column and I want to show in the summary row at the top of my sheet the number of PoCs and Pilots. Instead of just displaying the number, I want the cell to read PoCs = 22 or Pil…
1 Can I do conditional formating using more than one criteria (different Columns) We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the …
Hi everyone, I am new to Smartsheet so apologies if this has been answered elsewhere. I am trying to change RYG balls for a parent row based on children rows being marked done or not. I've used this f…
I have searched for a formula to calculate the number of days holiday, but I would like it to be more specific to tell me the number of days taken this month. So far I have this: =SUMIFS(Duration:Dura…
Can anyone figure out why this is happening? I have the date cell with =[Date4/7/20]@row but it's showing it as a different date. I cannot figure out a work around this bc using countifs to count toda…
I want to average the % complete column. I am writing the formula i the top row of this column and it doesn't allow me to do it. also, doesn't allow me to select any column from the same sheet. Am I m…
Hi All, I've been trying to find a formula to automatically calculate duration in months from start date and end date. I went through several threads here but none of them seems to fit at all. Could a…
Hello, I am trying to use this formula, =VLOOKUP([Facility ID]1, {Data Control Range 1}, 3, false) and it continues to come up no match or incorrect argument set, is there anyone able to help figure o…