Anyway Smartsheet can recognize the value in a cell as an email adreas and convert it to a hyperlink? Based on value in a cell in Sheet 2, an email address is "pulled" from a cell in Sheet 1. However,…
In Sheet 1, a user enters a course code (e.g., BUS 123) in one column. Smartsheet searches for that code in Sheet 2, finds the corresponding program leader's name and e-mail address, then puts them in…
I have an employee list that has a column for "supervisor", which is a "Contact" type column, allowing the selection of a supervisor from a pre-defined list. I have another sheet, a time sheet, which …
Does anyone know if there is a way to link an image widget directly to a selected amount of rows in a sheet? I currently only see the option to link to a full sheet, but want to direct the user to a c…
How can I work around this issue. My sheet is populating the "Contacts" via formula. I want to trigger automated update requests but am running into issues since I'm unable to convert the column type …
Hi Folks, We have been using a lot of cross sheet links and need to clean things up. Is there a way to see all the named ranges used to access data in a sheet? In other words, show all the ranges and …
Good day, Right now, we have several events happening in different cities on different days. For each event, we have a separate smart sheet, with individual planning tasks. but we want to have a combi…
Hi Folks, After reading up on the issue of cross sheet link limits, I would like to confirm what 'counts'. If a range is defined as having 10 columns does that count at 1 link or 10? If a range has 20…
Hello Community! I'm trying to calculate End dates based off of a hard Start date, and adding a number of Days that I have listed in another cell. The number of Days is calculated via formula, from on…
Working on a collection of sheets that I use between the different staffing agencies that service my operation. My Sr. Ops manager publishes a sheet (with the green shaded cells in the attachments bel…
