Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Smartsheet won't save changes after a sorting
This morning I did a sort on one of my columns so I could review and enter data easier. When I went to save the data Smartsheet told me it couldn't and to save data more often. I tried doing the sort and then saving after the first number update and I got the same error. The only way I can save my changes is if I don't do…
How do I revoke an individual publication of a sheet?
Hi, how do I revoke the publication of a sheet for certain people after having sent the link? Example: Two vendors shall be enabled to work together with me on a sheet showing issues within the project. I do not want to gain access to the whole workspace but I do want them to get the whole picture on the issues currently…
Formulas
I have two cases where I need a formula to work for me The first one is easy. I have two columns - Delivery Date and Delivery Date (2). I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell. I tried =[Delivery Date]1 but I get an error that says #number expected.…
Alstom Legacy Team Members
Our team has several Alstom Legacy team members. Does anyone know of any issues with Alstom users (Alstom email address) accessing & editing shared sheets?
Setting a project due date, then building tasks with predecessors leading into it - not working righ
I know there is a way to do this but for some reason I am stuck. I have an event taking place on 5/25. So that needs to be the due date and it CAN NOT MOVE. I then have maybe 40 or so tasks leading up to it, all of which have to occur in certain sequences. I am not able to set up the project. One of two problems occurs.…
Using "Contains" for Numbers
I'm attempting to filter a column with the following type of data: 10007789001 10007796003 10007789001 10007789002 10007801001 I tried to filter this column using "Contains" 7789. I expected every row with 10007789001 and 10007789002 would be shown. However, Smartsheet indicated that 0 rows met filter criteria. This…
Unable to set Outlook Reminders
Hello, We created a smartsheet and subscribe to the calendar using the publish to ical function. It displays correctly in Outlook, but when we try to set a reminder in the Outlook calendar it gives an error saving "the reminder for xxxx will not appear because the item is in a folder that doesn't support reminders". When I…
Project Management: Notices to be sent out to clients
Good day, I have ongoing jobs with my clients that require deadline notifications of 3-year renewals, annual and quarterly requests along with reminders. I use Smartsheet as a checklist with the various dates and when to start processing these reports. The issue that I am having is that my clients do not wish to log in…
Employee Anniversaries
We use Smartsheet for a number of different departments, HR being one of them. I'm wondering if there's a way to conditionally format a "hire date" cell to change colour when an employee anniversary is approaching? There is currently an option to conditionally format for a date that is a certian amount of days in the…
conditional symbol
Hello, I would like to know if it's possible to use a symbol linked to a result. For example: good result (up arrow) bad result (down arrow) automatically Thank you
