How do you convert the first row to mirror the header row? The Smartsheet template that we are utilizing requires us to use the first row in all formulas to pull information appropriately. When we typ…
I want to create a formula with a fixed date at the top of the sheet. There are subtasks with actions that must be completed a specific number of days before this event. Each row of tasks corresponds …
I am trying to figure out a proper formula to count two criteria within one column and a specific date in another column and feel like I’m tried every one except the right now so far and whether I’d n…
Basically, I want to know all the Issues for the 4 stars groups. Im using this formula to count the multiple values in a column - =COUNTM([Issue]:[Issue]) But I want to say, all Colorado groups have (…
I'm trying to count the number of times a word appears within a column range on another sheet; however, the cells I'm referencing have a dropdown so there may be more than 1 value per cell. I may be e…
I am having issues with getting this formula to work: =IF([Latest comment]:[Latest comment] <> "", INDEX([Latest comment]:[Latest comment], MATCH(MAX([Notes Last Modified Date - Helper]:[Notes Last Mo…
Hello! I am trying to have the have the status show as green when something is in progress, even if it doesn't have a start or end date. I only want it to turn yellow or green when there are end dates…
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying t…
Hi, I have a sheet that includes a multiselect contact field with RA names (On-Site RA(s))and a second contact field (Manager). When joesmith@email.com is one of the emails in the On-Site RA(s) field,…
