-
Can't build an alert - formula-based email not acceptable
Hello community! Anyone have a work-around for this? Here's the situation: I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the formula. When I go to build the condition in the alert (for approval), the alert will…
-
Check Multiple Boxes or Tag Multiple Items Within One Cell?
I know I've asked this in the past like 3 years ago but don't know if there mght have been a feature update or workaround for this yet. Is there a way to check multiple boxes or tag multiple items within a single cell? If I made a dropdown menu of 12 items for example, is there a way to check or select 2 of them for one…
-
Vlookup from Excel to Smartsheet
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple…
-
Weekly checks and scheduled tasks
Hi There, my support team has to check 600 - 800 technical setups on a weekly basis. They have to approach all systems physically and do certain routines. We want to use Smartsheet and its forms to easily document that process and generate reporting. We would populate a list with all relevant information and generate…
-
Card View Stacked?
Hello, I understand why card view runs left to right. We are using card view to plan the layout of a 100 page magazine so we have 50 lanes. But there is only ever 2 tasks/cards per lane. Is it possible to stack the card view so we can see more lanes to view as visually this would be easier for us to manage this process?…
-
Transfer Sheet and Report Ownership While Keeping in Same Folders
An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and licensed user on Enterprise account.
-
Tags (possible feature request)
Hi, is there any way to tag rows? I can use a dropdown list, but that only allows for one "tag" per row. I could also use a comma-seperated list, but without autocomplete and/or tag-management it's a very error-prone approach. All feedback is much appreciated!
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
I need to restrict access to a web form to only a specific group, can I do that?
I am using Smartsheet as a project list and a web form as a work request system. I need to restrict access to the web form so only spefic people can file a request. is that possible?
-
Modifying RYG Symbols with Dates and Status
We are trying to create a formula on the Schedule field that will change color to Red, Green or Yellow based on Multiple day and Status selection. For example: If Status is In Progress and End Date is > Today and R - Date is Empty then is Green. IF Status is In Progress and End Date is < Today and R - Date is Empty or a…