-
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…
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
-
Project with Multiple Dates and Hours
I'm working on a project that I completed over two days and want to document my hours for both days. Sometimes we work on projects over several days in different weeks. How can I enter all this data. Right now I only have one column for Date and Hours. Am I able to add more columns to enter more Dates and Hours?