-
Modeling uncertainty: "Expected Value" for staff allocations on future potential projects?
My company is a consulting firm that must manage an uncertain project flow. We use one Smartsheet per project, creating a new project smartsheet whenever we submit a project proposal. However, there is always uncertainty as to whether we will actually get any particular project. We definitely don't have a 100% success…
-
Download a Copy
I am currently trialing Smartsheet and am loving it so far. My question is what if there is no internet access, internet failure. Is it possible to download a copy of the file so that there is a backup you could use if no internet access? Thank you Carolyn
-
Is it possible to create a link for each column to be copy and paste elsewhere?
Hi, The feature I am looking for is basically to copy a link to a row for pasting it in my iCal at the event that corresponds. For instance, if I have to call the Opportunity in row 100 at 4pm, I will manually create an event in my iCal (becasue SmartSheet sync with iCal only adds them as all day events). In the event in…
-
How can I allow Viewers but prevent them from getting an update very time that i make a change to a
How can I as an Administrator allow Viewers to a sheet but prevent them from getting an email every time that I make an update to the sheet? I was not aware that these were going out to every person who has Viewer access.
-
Adding preceding zeros to a number
I have a column with 4 digits and want to add preceding 5 zeros. I can do single column with '00000 and the number, but I have to do for 4,000 rows and the number are different in every row. Is there a way or formula that can help me add preceding zeros. Thanks
-
Is there a way to add sheets to multiple reports at the same time?
Hi, I have set up a bunch of different reports across multiple sheets. These reports include 'Tasks Due Soon', 'Overdue Tasks', 'Tasks Assigned to X', etc... Many of the sheets we have created use the same template (Standard Project Template) so that they work consistently with reports, but some of our sheets have…
-
Dashboard Views
Newbie to Smartsheet, only in trial period but likely to purchase. Is anyone doing anything with a dashboard view? I can see that you can export into Googledocs but I was hoping to have a dashboard page of my projects within Smartsheet itself.
-
Sorting based on row color
Is it possible in Smartsheet to sort by color so that all rows in the same color comes after each other ?
-
Syncing Smartsheet Calendar with Google Calendar
Hi I would like to sync my smartsheet calendars with a google calendar so that I can have one centralised calendar for all of my sheets. However, when I sync them, I loose the conditional formatting (which I use to colour code the different types of tasks/appointments in smartsheet). How do I maintain the colour coding?…
-
How to use a range of numbers in a formula
Hi SmartUsers, I have a formula to show bars according to the completion % of a cell. The formula is: =IF(Completed?9 = 1, "Full", IF([% Complete]9 = 0.25, "Quarter", IF([% Complete]9 = 0.5, "Half", IF([% Complete]9 = 0.75, "Three Quarter", IF([% Complete]9 = 1, "Full", "Empty"))))) It'll show 1 bar if a task is 25%, 2…