-
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…
-
Folder in Attachments area
For our particular needs we find ourselves needing to separate attachments into categories - new or previously used. Is there an enhancement on the horizon that would allow the creation of folders, or an option similar? Blessings, Loann
-
Excluding cells from COLLECT based on value
Hi All, I am trying to write a COLLECT which excludes results based on the value of a cell, similar to how NOT(ISBLANK(@cell)) works. Below is a formula I have made which works, but I was hoping there was a more succinct way to achieve the same result =JOIN(IF([Audio Language]153 <> "English", COLLECT([Audio…
