-
Duration is WAY OFF
I know I'm getting old, but at this rate I'll never see the end of this project! :) Pay close attention to the duration column here. These numbers don't add up! Also, I've already submitted a help ticket. I'll post back here with the response. Thus far, this is the only row I see like this. For what it's worth, the mobile…
-
Desperate for help-dashboarding
Ok about to rip my hair out on this. I am needing to create a portfolio view dashboard and when dashboards were widget driven I COULD DO THIS EASILY. I just want numbers for the following on the dashboard- # of Executing projects by PM (Name) # of projects >50% # of projects <50% # in Yellow, Red, Green # Paused (yes this…
-
Copy/Paste Cell linking
I am trying to use the paste special option to link a cell but the "Links to copied cells" radio button is grayed out. I've tried this on multiple sheets, and it still will not give me the option.
-
Tracking Time Between Tasks
Hello! I want to show on a dashboard the time it takes to get to each step. For example, I have five columns - all are checkbox columns where each time one is checked it automatically alerts the appropriate person to move onto the next step (a new column). When all five columns are checked, the task is considered complete.…
-
TimeStamp Formula Value
Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match up my name and the time/stamp data and put it on my master sheet. Any suggestions,…
-
Calendar App Add-on - New Event
Hello, Currently, I have the add new event function enabled for the calendar app. The calendar is pulling from a sheet which has a column where I am using a formula to format the event info in a way where it can be easily read by our team. Is there currently a work around to "hide" the formula column from being accessible…
-
Email Notification Collation
Hi SS Community I am triggering some automation within another tool when receiving an email from smartsheet notifications. The problem being sometimes smartsheet collates emails when there are a few to send and sometimes it doesn't. Is there a way to control this behaviour as it makes it harder to cater for both outcomes…
-
Dashboard information depending on a selection
Hi, I just began using Dashboards and I have a question I´ve not able to answer. I have a project portfolio and several projects. The project portfolio is a centralized Smartsheet and its related to all the individual project smartsheets. I´m trying to build a Dashboard where you can select one of the projects of the…
-
Setting a default value in a sheet
Hi Everyone , Is there a tip to set a default value in a sheet column ? I know it is possible to do it by a webform , but it is not my concern . I have a drop-down list column , with 2 items : "Oui " et " Non " . How can I manage so that " Non " value is displayed in the column by default every time a new row is added .…
-
Smartsheet cell data linking to excel or word.
Hello to all. We are about to jump into smartsheet use for our company, however I would like to know about functionnality: is it possible to link certains Sheets data to a Word or Excel, offline template, in export ? Here is a usage scenario : We do need to manage IT rollouts projetcs, with Site surveys, Installations, and…