-
Web Form Completion Remiders
Is there a way to set a reminder asking users to complete a web form?
-
"Save As New" doesn't retain Auto data...
I use a separate sheet to track projects in each calendar year. This means I need to carry over partially completed projects rows from the previous year's sheet to the next year's sheet. I've used a "Save as New" to duplicate the sheet, formatting and data, but my "Submitted" column which contains the "Date Created" now…
-
Smartsheet API report creation
Hi, We have a lot of reports, they have only small differences. Normally it is just a filter e.g. name of "assigned to". If we have to slightly change these reports, we have to change all the reports by hand. Is it possible to create/change reports with the API? I tried to do it but i did not found it in the API…
-
gant bar color
Hello, I am desperately looking how I can change the color of a gantt bar. Right clicking on it .. only shows me "edit" option .. but not "color" option. conditional formating : If I select to apply a color to the whole line .. then it allows me to indicate also the gantt bar color .. . If I select eg red .. it doesn't…
-
Auto populate Percentage Complete
Hi, I have a "task" in my sheet which lasts for 3 months. Is there a way to autopopulate the percentage complete based purely on the time passed? It is not a measure of outputs / delivery but just showing how long an external resource is in place. For example, after 1 month, it would say 30% complete. Many thanks, Siobhan
-
Gantt Chart timeline issue
Hi there, When I try to print a Gantt Chart the timeline is in, say, months or quarters, but when I press the printer icon it automatically converts to a weekly timeline. Does anyone know how to control the timeline when I print? Thanks, Paul
-
Resource View - show detailed tasks when clicking on %'s
Hi! I would like to suggest that in Resource View, it would be very helpful to not just be able to click on the arrow by the person's name, but take it one step further. It's nice that the project link is there, but clicking the project link only opens the project without show you what TASK in particular is scheduled for…
-
Change Start Dates from a Template
If I have a 30 Day project Template saved and it's start date is 1/1/17, is there a way to easily change the start date on new sheets I create? Essentially, I would like to create a new sheet that would start on, for example, 3/3/17. Everything from the template would be moved over exactly, except the first item would now…
-
Bar charts in tables using REPT function
I know SS is working on embedded charts for Sights but an easy workaround would be to have bar charts in a single cell using the Repeat function as in Excel. This is really a Text based formula cheat whereby a "|" is repeated by the value in question (i.e. =REPT("|",Ref) ). So, if you had a table and you wanted to rank the…
-
Date AND Time format
Hi I was wondering if there was / is a way to format a cell to be date and time format? We enter in when we contact a customer for the 1st time and have to track the date and time. It would be nice to do so with one cell where we click the cell and a time stamp of now (but editable) is available. Is this a current feature…