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. Archived 2017 Posts
Archives for July 2017
Discussion List
Creating user Dashboards as Sights - filtering
I am creating sights for team members on my projects so that they can see their assigned tasks all in one place - no doubt a common use for Sights. Anyway, when I link multiple sheets into a report and expose the sheet name, when the user clicks on that link, they are taken to the sheet and not the row. Is there any way to…
Forumal to reset the Check Box
Has anyone used a formula to uncheck a check box? I am trying to set up a formula to check to see what day of the month it is and so far I have most of it working I am just stuck on the check box portion as my conditional formatting looks to see if the Done box is checked as well as it is past the 1st of the month.
Best way to set up a sheet to track multiple IT projects
Our IT department has several projects we want to track. I need advice on the best way to set up the sheet(s) so that we can see the details of each project and have the ability to see all of the projects on one sheet. Which option would be the better set-up? Option A - Have one sheet that lists of all the projects with…
Problems with Cell Linking working on some cells but not others
I help develop Smartsheet sheets and reports, and link cells from project plan sheets to an overview portfolio sheet. Recently I've seen where some cells link properly, but some cells don't. I've tried removing the links and re-linking, but to no avail. Guidance is appreciated.
Is there an formula edit window?
Is there a formula window available so I can edit/create long formulas better? The one the pops up when you start typing in a formula overlays other cells and makes it difficult to select columns int he same row. I'd like to have a separate popup that I can move around on the scree or make bigger so I can see and work on a…
Range Starting point and then the rest of the row.
Hello, I am trying to reference an ever growing range in a COUNTIFS formula... but it starts at about Cell 150... I would like to have the range 150:infinity... any Ideas?
Clone a widget to another sight?
I've got a nice set of KPI's pulled together on a 'demo' sight that I was reviewing with my team. Now that we're happy with the look and feel, I'd like to publish them to a different sight for a broader audience. I know there's a 'clone' button. I don't see an option to 'clone' a widget to another sight. Is the only option…
Scheduling an Update Reminder like an Alert
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and every time; keep in mind I…
LastChild() function?
Is there a way to display the value of a cell from the last row of children in a given parent row cell?
Help wanted
We re looking for a subcontractor to assist in design and implementation of construction scheduling, task management, and resource allocation for a small construction company. Presently, working with Microsoft Project and need to revamp our solution with Smartsheet to be more detailed, efficient, and useable.