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 September 2017
Discussion List
Webforms & Populating Multiple Rows
I was wondering if there was a way to create a webform in basic project gantt view that allows people to populate multiple rows for dates? We have a critical path template that we want to use for our suppliers to fill out dates but we don't want them to change the content that we have listed - Just the dates. I know I can…
How do I auto check a box based on a date + x # of days?
Can I get a box to auto check (so a conditional format is triggered) based on a date + 4 weeks? I want the sheet to auto tick a check box for me when something is 4 weeks past a specified date column. I want that to also correlate to another column that has a full harvey ball or % value of 100 or even just another tick…
WORKSPACES
We recently had an employee leave who created work spaces and when we transferred ownership those workspaces turned into sheets and i can not move them back to the workspace folder. please help! i need them moved for my reporting.
Showing a task duration in the Calendar View
Does anyone know how to show a task duration in the Calendar view? I can only see the task on the date it starts and I would like to see an extended bar for the task that goes from start date to end date. I'm a Smartsheet beginner and would appreciate any assistance!
Help Please =IF(TODAY()
=IF(TODAY() - [Expected Close Date]2 - 90>120, "3-6 Mths") If todays date 08/09/2017 Nz or 09/08/2017 Us (Built in calendar in Smart Sheet) looks at the date I entered in to my Expected Close Date column 14/02/2017 Nz or 02/14/2017 Us then it will return "3-6 Mths" being that 14 Feb date is between 90-120 days ???? Am I…
Duplicate Columns in Report
Hello, I have four different promotional calendars that I am trying to merge into a summary. Each has month/week/day/date columns. When I create the report I want one set of those columns and then the promo/notes/$ etc from each individual sheet. Is this possible? It's very unsatisfactory to have four rows of dates with…
Parent-Child Formula for Percent Comnplete
Good Day All: How can I change the following formula below into a parent child relationship so if I add additional rows, the parent will automatically include the child in the calculations for overall percent complete. Does anyone have the Smartsheet % Complete Formula that is hard coded within the Project Settings? Thanks…
Sharing a calendar in an iframe from another system - need HTTPS
I have a sheet that looks great as a calendar. I can use the Publish Options to share an HTML version of the calendar. When I enable this, I get a URL like http://publish.smartsheet.com/xxxxxxx. I would like to include this in an iframe on another site; we use CA Agile Central, previously known as Rally, in which I can…
I need both dependencies and predecessors
I have used the predecessor column and love it but I need to also have a dependency column. For instance if I have task 1, 2, and 3 and 3 has a predecessor of 2 and 2 has a predecessor of 1 then I want to know that 2 has a dependency of 3. Knowing the predecessor only tells me what needs to be completed before the task. I…
Integrating Smartsheet and Mercatus
Hi, Does anyone know if you can integrate Smartsheet and Mercatus? Thanks, Y