-
Repetitive Task List Instantiation - Editing Multiple Tasks From a Master List
A common experience we encounter is when we have long, identical lists of tasks (7 or more), indented under many parent titles, that need editing, as shown below: PARENT ONE * Task ONE * Task TWO * Task THREE. etc. * PARENT TWO * Task ONE * Task TWO * Task THREE. etc. We have many PARENTS with identical lists of tasks that…
-
Attachment Permission
Is there anyway to share a sheet but not certain attachments? I have all my sharing permissions set but there are certain attachements I do not want available to certain users. Smartsheet is working great for my team with the exception of attachments.
-
Removing Answer Choices from Webform
I am making webform for event sponsorships. I would like the sponsors to select which events they want to sponsor - but each event can only have one sponsor. Is there a way to have a dropdown menu that eliminates choices once someone else has selected them? For instance, if I have sponsor event A, event b and event c, then…
-
Nested IF's Based on Date and Additional Criteria
Hi All, I am trying to craft a formula that will help automate the pacing of tasks. I have four columns: Task Name (Text), Task Completed (Checkbox), Task Status (Green, Red, Yellow, Blue), and Task Due Date (Date). For Example. [Determine Target Audience] - [Checked] - [Green] - [1/24/2017] I am trying to automate "Task…
-
Automatic Column Updates?
Hi I am trying to create a formula that is set for the whole column in the sheet. What I want to happen is whenever the Status of the Harvey Ball is full, the "Done" column well create a check mark in the cell. Is this possible? If so, how? Thanks.
-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
-
Capturing Email Responses
I would love and really need to capability to for Smartsheet to capture responses to emails in the comments. Example if a user sends a document for comments through SmartSheet email as users reply back I would want to see those replies in the comments. Rather than having to log into smart sheet leave a comment and then…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Gantt Chart - Show Repeat activity every fortnight / month etc
Hi All I am wanting to show an activity that needs to happen every week or month on a Gantt chart in one row. Any suggestions please?
-
Annual School Operations Calendar
Can anyone recommend a format for an annual calendar for our school operations team? What I'm trying to create is a document to input all school activities for the year and plotting each department's tasks for each job. For example: School Open Day: events showing each department's tasks to achieve effective outcome. So…
