-
Display URL on a form based on response to a question
I am trying to build an up front "routing" form to re-direct users to other smartsheets based on their answers to the first question on my form. Based on which value in the dropdown they select, I'd like to display only the appropriate URL of the other form. I want the URL to be clickable, and i'd like to hide the text…
-
Conditional formatting with AND not working as expected
I've created a conditional format using and that states if the date in a column is in the next three days, and the column next to it isn't yet filled, make the cell yellow: As you can see below, it's filling in yellow even when that "send to copy editor: actual" is NOT blank: Any recommendations?
-
Move Row and System columns
Hello community! I set up a 'Move Row' automation with the intention to archive a large sheet at regular intervals. There are several System columns on the source sheet (auto number, create date etc). When a set of rows is first moved to the archive sheet, the archive sheet reflects the same create/numbering data…
-
Formula Help w/arrows
Hello, I need help with the following formula: =IF([Risk Level Total (IMPACTxPROBABILITY)]@row = 25, "Down", IF([Risk Level Total (IMPACTxPROBABILITY)]@row <= 20, "Angle Down", IF([Risk Level Total (IMPACTxPROBABILITY)]@row <= 12, "Sideways", IF([Risk Level Total (IMPACTxPROBABILITY)]@row <= 10, "Angle Up", "Up")))) I need…
-
Drag and Drop task using Calendar View
Hep! I am trying to drag and drop tasks using calendar view but it is not letting me. No error message just unable to move it.
-
Webinar recording available: Collaboration Best Practices
Missed the webinar? Review the recording in the Learning Center. Drive collaboration and transparency across your teams and organization, allowing everyone to work together to achieve more. In this webinar, we’ll share the many ways to collaborate using Smartsheet: Share sheets, reports, and dashboards Intake information…
-
Can I import report data into a Smartsheet? Or another suggestion?
I know, it sounds odd. But I use Smartsheets to prepare quotes. Once a quote is approved and a project can move forward, I run a report to gather up all of the material and hardware needs. Works great, but I end up copy and pasting the data from the report into a Google Sheet so that I can break down materials being…
-
Anyway to set Hierarchy for columns?
You can group rows into hierarchies, but is there any way to group columns?
-
Subtask Summary not Updating in Card View?
In Card View, my Subtask checkboxes do not tally at the bottom of the card (Full View, closed card). This is a new development. Any thoughts to help? Thanks!
-
Creating a project programme from a number of Project plan sheets
Hi All, I have project plan sheets set up for my project managers to use. each project has 4 phases which have parent rows set up to catch up each phases progress along with a top line project row that captures overall project progress. I have created programme reports that look at these sheets to show a project by project…
