-
auto-populate date formula when column is checked
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 kindly!
-
Display values from a row when a value in that row is a specific value
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 value is "yes", I would like to display on the report the details of the workstream, the owner, and the reason it is blocked.…
-
Best practice to notify/ask if someone's name is selected from a drop down?
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. Once selected they are emailed with info from the grid asking if they are free during form submitted time (ex meeting time).…
-
Help with SUMIFS
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}, {Date Task 1 Complete}, >={Week 1 Start}, {Date Task 1 Complete}, <={Week 1 End}, {Assigned To}, Employee@row) ALL results…
-
Cross Sheet Reference Shows #REF When Row Is Moved
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 everything working, except when I have the row removed from the intake sheet (because it's been completed) I get #REF in my sheet…
-
CountifS with Distinct
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 SID}), {Total URV Visits BEC}, District@row)
-
Redefine a formula for status and date
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 words: Green - Complete Yellow - In Progress Red - Not Started In addition I want the Certificate date field to be automated…
-
Ability to Find & Replace text in Formulas
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 extremely helpful and time-saving. As I type this, I have the daunting task of going back to my sheet on SmartSheets and…
-
Help with INDEX/COLLECT with a MAX/COLLECT
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 like to use the row with the MAX Fully Executed Date. Below is the formula I am using: =INDEX(COLLECT({IA Assigned}, {RTO…
-
How? Column Formula to Pull Level 1 Parent Task Name
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 cell in the 'TEST' column to display the name of its Level 1 parent, such as "baseline estimate" or "estimate R1," depending…