-
Copy Parent Issue Key (link) into Child Row as a link
Hello! I am trying to pull the issue key link from my parent row into the child row. I have used the formula =PARENT([Issue Key]@row ) But it returns the text only, not a clickable link. Any ideas?
-
Attachments to In-Cell Images
I cannot figure out how to automate the process of moving cells to images. I've read this can be done through power-automate, but frankly coding is out of my expertise. Is there a simpler way to do this? These attachments are added through form entries.
-
Multiple Forms - Add info to existing row
Hello! We work with a registration form that feeds a master sheet, we want to add another form that will update or add a request for change for a registered contact, but we do not want to generate a new row, we want Smartsheet to match the name or ID to the initial registration and update the columns. Do we need a formula…
-
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…
-
New to formulas: auto creation of + or - 4 week visit windows
Hi, I am new to formulas. If I have the initial visit date in one column, I'm wondering if there is a way to have actual dates inserted in preceding columns based on the initial visit date: 1 column showing the next possible visit date +X week or days date max and then in another column the -X week or days date min. Is…
-
Auto numbering with 3 letter pre-fix
Hi All I am using the below formula to generate a unique ID based on the first letter of the selected type. This works well if all types start with a different letter, however i have 3 types that start with P =IF([Row ID]@row = "", "", LEFT(Type@row , 1) + "-" + [Row ID]@row ) Could you please show me a formula that will…
-
Date Column 1 < Gate Column 2 = At Risk
I have a Target Date column and the typical Finish column. I am looking for a formula that will tell me if Target Date is less than Finish Date mark the cell AT RISK. But if the Target Date cell is blank leave it blank. =IF([Target Date]@row > [Finish]@row , "Yes", "AT RISK") I can't get the ISBLANK to work.
-
Metric Sheet - Not updating with Automation Date
Hello everyone, For the past year or two, I've been using automation "Record Date" set to daily as a trigger for the cross sheet references on this metric sheet to update. As of recently, it stopped updating the references despite the automation running and updating the date. Was there a change that broke this? Thank you.
-
Index/Collect function returns #INVALID VALUE only when the formula comes back with an empty value
Hi folks! I'm trying to reference a cross-sheet cell value using the following formula: =INDEX(COLLECT({PM Practice Training Completion: Completion Date}, {PM Practice Training Completion data: LXP ID}, [LXP Course ID]@row , {PM Practice Training Completion data: Username}, "Test User"), 1) This formula is located in a…
-
Count Distinct Using a Text Column with Values Separated by Commas
Hello! I have a column with a list of values separated by commas. I am looking to count the number of values separated by commas and eliminate duplicates. I have tried creating a helper column that converts the values to a multiselect, but I can't figure out the =COUNT(DISTINCT formula from there. Here is a screenshot…