-
Complete a Partial Update Request
Our marketing department sends update requests to our project managers so that we know which projects are expected to be marketable projects. If they are marketable then it triggers other actions. Often, I have 10+ projects that I need a single project manager to update me on. Is there a way to send an update request that…
-
Formulas and Sheet Saving
All of the sheets in my solution have a date column for "Today". =TODAY() I use formulas in several other columns to determine if the checkbox column for Current Qtr should be checked. (same for Previous Qtr and Next Qtr) I use the checkboxes in report filters. Problem: Because my formulas are updating sheets daily, I have…
-
Non-working days for the enterprise
Would like the ability to set non-working days for an enterprise, with the ability for individual smartsheets to opt-out.
-
Designating Focal Date in Calendar View
Does anyone know if it's possible to have the calendar automtically use a date prior to today's date as the focus when displaying the 1 month, 3 week, 2 week, etc., display? By default, it displays the current week at the top of the calendar whenever the calendar is opened. Also, whenever I refresh the browser, the…
-
Reoccurring Event
Does anyone know how or is there a work around for entering a reoccurring event one time but have a reminder sent to you every two weeks vs enetering the event multiple times?
-
Automate archiving of completed tasks
I've copied a sheet of "Current Tasks" so that I can use the copy to archive my "Completed Tasks," otherwise they just fill up my task sheet. I notice that there's a feature for linking cells, but I'm trying to figure out if it's possible to have the rows marked as "Completed" automatically copied to the "Completed Tasks"…
-
Is there a way to get the autonumbered Row ID to display in the web form that feeds my smartsheet?
It appears that system columns cannot be added to a web form. I need a way to assign a number to each submission that the submitter can see in the email that is sent back to them.
-
Ideas for Multi Department Service Request tool
All, We are currently using Smartsheet as a Help Desk Ticket system for one system, with two developers and two users that submit bug or enhancement requests. A webform is used to submit the request and email alerts and conditional formatting are used to track the status of the request and notify users when anything…
-
One tab, multiple reports?
Smart Sheet has proven to be an amazing tool. In using it, I have built several reports that are starting to take up too much space on my display. Some of these reports are very similar (Quarterly reports, for example, are taking up four tabs per year) and I want to consolidate them into one tab. How do I create multiple…
-
Is there an ETA to add the ability to Merge Cells?
I need to be able to merge cells and I read the posts that it is not availble but "votes will be put in" for it. Is there an update? I can't imagine it would be very difficult to add the functionality and it would make managing projects in SmartSheet much easier. Note: Changing the background color will not work as…