-
Merged: Colour Column Header Row
This discussion has been merged.
-
Streamlining Automation Requests/Form Options
My team is looking to use Smartsheet capabilities as we continue building an dashboard for tracking KPIs across various project initiatives. Each initiative has its own row in Smartsheet, and we've included the initiative owner in the corresponding column. Some initiative owners are listed for multiple initiatives. We're…
-
IF Formula working on some and not on other items in column
Hi All, I have a formula running in a column to validate an action based on whether it was done prior to 01/01/2011 or not. =IF([Install Date]@row >= 1 / 1 / 11, "Yes", "No") The formula works as required on rows where there is a year only, but throws #INVALID OPERATION where a date has been entered through smartsheets…
-
Reactivating Business Plan: Will my existing sheets and permissions be fully restored?
Hi, I have a question regarding reactivating my Smartsheet subscription. Previously, our team used a Business Plan with one Admin (Owner) account and two additional licensed users. We canceled the annual subscription some time ago, so our account is currently inactive (or in read-only mode). If I log in as the original…
-
Record a date - From/To
I am trying to record a date when the value in a status column changes from "Closed" to anything else. My research shows that I should be able to create an automation using the condition Status Changes From Closed to Any Value, if the status field is a single select drop down field. I've confirmed the status field is a…
-
Update requests not showing up
Has anyone experienced an issue with Update Requests not showing the icon but still going out to the parties that it should? (We refreshed and did a Ctrl + F5 reset) We have experienced a ton of these and while it is only a graphical issue for checking status's this gets confusing. ~MR
-
Automation workflow not including attachments in notification emails correctly
Hi ! I am trying to figure out why some email notifications include attachments and others don't. I have a few teammates who add attachments to the rows when certain columns are triggered by a checkbox. I have my automations set below. And you can see once column was checked email includes attachment, but same email it…
-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
Auto Number column will not reset
I need to reset my auto number schema to a different format. However, when I do, all new rows still use the old format and continue with the same numbering. I have tried deleting the column, saving and recreating but it does not work. I have also tried the web version and desktop app and get the same results. I have…