-
Easier and shorter "If" formulas
Ability to select a value from one dropdown list, and then have a second dropdown list display only a limited number of options based on that first selection. Example: Column 1: Zip codes (user selects a zip code) Column 2: Flu vaccine dates (only the dates available for that selected zip code appear as options)
-
Resize Image on Forms
Allow user to increase size of image on forms so that logos are more prominent and easier to read
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Smartsheet forms (published) keep refreshing removing all data.
Hi, there might be a bug in Smartsheet. Recently, I have received many complaints from people across the company, telling me that every time they try to fill out my published form, their browser keeps refreshing for some reason. This has also been happening to me while I was providing some training; the form would refresh…
-
Report not pulling from one of the selected pages
I have created a report for my boss called the "latest comment report". It pulls the latest comments within the last two weeks from all my active project sheets. It is working great for the most part, however the report is not pulling the latest comments from one of our project sheets. All active project sheets have a…
-
How do I delete a file that I am the owner of but it says I don't have permissions?
Hey all, I am the owner of a workspace in smartsheet and there is a file that I created that I want to delete and smartsheet says I do not have access to do so. Even though I am the owner. When I request access to the file (because it says I don't have access) it send me a request but when I approve it, nothing changes…I…
-
Project Dashboard
Is there an easy way to identify which cell or group of cells is being used for the information relaying from a sheet onto the dashboard?
-
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
-
Unable to log in with my coroporate account
For over two months now i am unable to login with my corporate account to access our corporate platform, i keep receiving error message of being unable to login with my account and that my account is locked. Even the option of requesting for the code which send it to my email account i still do not receive. How can i…
-
Need help with a formula to look at multiple columns and insert a value in another column.
Currently I have the following formula in the Grant Status column to indicate active or inactive based on the end date. Now I need to add Deactivated as a status based on if the FY Start is NA. If NA is the value, then Grant Status needs to be deactivated regardless of what End Date is, whether blank or has any value.…