Hi All! I am looking for a way to add the date to a column when a check is placed in another column. I would want the date the check mark was added to the column. Any advice for the formula? Thanks ki…
I am trying to create a reporting dashboard that displays elements of a row when a value in that row is "Yes". For example, if a workstream is blocked, the reference cell is "Is Blocked?" and if the v…
Greetings- I'm trying to figure out if the way I am doing it is the most streamlined way. I have a column called assigned staff where someone can select a single individual or multiple staff members. …
I am trying to collect the numerical value based on whether or not work was completed between two dates by a specific employee that was assigned to the work, using SUMIFS. =SUMIFS({Numerical Size 1}, …
I have an intake form setup in one sheet and in another sheet I have a bunch of formulas to format the data from the form into a csv that can be used to upload the information into Jira. I have everyt…
I need a function to count how many time a territory as unique SIDs in a sheet. I tried the function below but it won't work. =COUNTIFS({Total URV Visits Range SID}, DISTINCT({Total URV Visits Range S…
Changes needed to my current formula. There is just too much going on, I want to simplify this. My current formula in the "Certification Complete" is below. Now I also wish to change these colors to w…
Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is ext…
I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would…
Hi Smartsheet Community, Please see image of setup! I am trying to create a column formula for the column 'TEST' that pulls the name of the Level 1 parent task for each row. Essentially, I want every …