-
Feature Request: Switch, Vlookup, and/or Lookup Functions
Please add one or more of the following functions: switch, vlookup, and/or lookup. Note that this would make it easier to reference rate categories in a rate table without having to use a huge nested if function.
-
Assistance with a formula -- similar to VLookup
I’m not sure if this is possible in Smartsheet but I know the Community will know! For our Annual Meeting, I created a blank sheet that will help us manage our schedule and assigned meeting rooms. Some of the columns are: * Meeting Room Name (the name of the hotel meeting room) * Capacity-Conference (the capacity of the…
-
Copying Rows
I'd like to be able to add 1 row to multiple sheets at the same time. All of the sheets are from the same template, so all columns are identical. The best thing I have found so far is to create the row, then copy it to 1 sheet at a time, but it's still very time consuming. Any ideas?
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
Lookup function into a report
Hi, I have one smartsheet which tracks projects within a continuous improvement process where I can define if a project is high priority or not. I wish to pick-up this indication up and using in other sheets that reference the same project id e.g. a risk register and action tracker. As the original sheet has multiple…
-
Cell Links Broken - Issue
Has anyone seen any updates regarding the Cell Linking issue? I reported it on Thursday, but they say it's in their Tier 3 team's hands for investigation. Thanks!
-
linking two columns togther
Hello Everyone, I have two columns, one has the name of the customer "name" and the other column has the number we assigned to the customer "number". I am trying to link these two for example, let us say if I type 111 in the number column the name joe will appear in the name column, and the other way around. If I write joe…
-
How do you pull form data in sights directly from a sheet?
I am trying automate pulling data entered in the form, that pulls into the sheet to then pull into a sight without using a report as the formatting is not very good, can anyone help?] I have attached a screen shot to support above. Thanks
-
Master sheet overview
Hi I am currently working in a team where many projects (not necessarily related) are running alongside each other. We would like to create a smart sheet master template/dashboard that allows the project manager to manage his/her own smart sheet for the given project themselves, while all the data from the particular…
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…