-
Date-based formulas now broken across 100+ sheets
As a result of the latest release and supposed "formula enhancements", we now have more than 100 client-facing project sheets whose "status" column is entirely broken. Previously our status column looked at the task Start Date, End Date, and Target Date, and intelligently spit out a text value such as Due Soon, In…
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
Large doc with rows of data - dates
I have a sheet that we use to co-ordinate service work. It is getting pretty big. Is there anyway to have Smartsheet automatically go to todays date on the sheet, as opposed to starting at row 1?
-
Alerts to non-shared resources
We are trying to implement an editorial calendar. Smartsheet works great for this in theory.. ie: we have the primary row as an calculation that shows us: "Client (Content Type) Title (Creator name)" - perfect. this is awesome. We have the due date as the calendar date. - Again.. perfect. HERE IS THE CHALLENGE We have…
-
Auto-fill formulas and corrupt references
Hello, I'm currently in the process of setting up a rather formula-heavy project sheet, linking project names, project numbers and multiple assignees to all the different tasks within the project. In order to circumvent the limitation of one assignee per task on my sheets, I've created additional (non-Contact list) columns…
-
PDF Viewer - Feature Request
We request the addition of a PDF viewer in the browswer window. In our use of Smartsheet, in particular for administering the implementation of the construction of a building, the workflow would be speeded up considerably if the PDF could be viewed in the browser, rather than downnloading an opening in a separate PDF…
-
Auto-increment a new form entry if it matches an existing name
My team is using Smartsheet to track interactions with our customers on Facebook. To keep a record of the interactions, we're using a form to populate a sheet with the data (time, date, sentiment, that sort of thing). I'd like to find a way to automate one of the questions in the form - how many times we've interacted with…
-
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
-
How to fix a project launch date
Hello all, I have a project with a fixed launch date - what i need to know is whether i will hit that date. If i set dependencies with predessors then it moves my launch date.. but if i set the date as fixed for the launch i cant set up the dependencies on the previous actions... Am i doing it all wrong? How can i set a…
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
