Hello, I have a group of sheets that populate a report with date data. One of the date columns is a formula column that is constant through all of the sheets, used to track various processes to calcul…
I am setting up an on-call schedule for all of the teams in the department. I want the start dates to auto-calc based on the prior row for the same team. I used AI to create a formula and it works. Bu…
Hello. I'm working with a worksheet where I'm trying to put a Workers management team into the correct column based on the Managers Management Level. I'm able to see the flow of an organization by usi…
I have a working sheet that utilises the Created Date functionality by Smartsheet (DD-MM-YY HH:MM). I am looking to count the number of rows for every Month in a separate sheet to see new rows added o…
I have a form where a user identifies all the people from different departments and input their names in the Team Column. There are times when people are not filling it out for various reasons (wasn't…
Hi there, I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, p…
Hi, I am creating an Escalation Tracker for one of our teams. Escalations will be entered via a form and the Submitter will choose their name on form. The Submitter will need to select an Escalation T…
I'd like to remove characters from the right. What formula would I use? Example: Person's Name (FL) I want to remove the (FL) part and have the cell only reflect the person's name. Thank you!
I am using Smartsheets as a daily tracker for my prayers. I am creating a form for this tracker. I have a pre-populated Date Column and then 5 prayers columns with dropdown column options of yes and n…
Hello! I'm trying to create a helper column with conditional formatting to identify duplicates in a column. The numbers in this column are employee numbers pulled from an HR report, so I cannot change…