-
IF, AND/OR, NOT formula with multiple conditions for a symbol column
Hello, I have been using a symbol column to monitor updates for a master sheet of all of my departments projects: =IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")) However, I need to update this formula to include criteria that states NOT if the Phase@row is…
-
Smartsheet Automation Email - Sender
I've set my automations to Send from Smartsheet Automation. Some emails are right and others still show they are from the sheet owner. The emails are from the same automation. Does anyone know why it does not consistently work?
-
How to split multiline cells into individual cells?
i.e. if a cell looks like A B C How to get A, B and C into separate cells?
-
Can I submit multiple dates in a form for one event?
I am trying to build a social media content calendar. We have our posting schedule laid out at regular intervals prior to the event. For example, if an event takes place on March 17th then we would have a post going out on March 10th, a reminder going our the 16th, and another post the day of the event. I am using…
-
Portfolio Report exists & has current data but isn't showing in either Blueprint for me to edit??
We have 2 Blueprints set up in our Program & we have a Portfolio Report that currently pulls data from 3 sheets (it pulls the same 3 sheets from both Blueprints). We actually only want it to pull from 1 sheet in each Blueprint, so I went to Control Center & clicked through the pages until I got the Dynamic Report Scope…
-
Troubleshooting Data Shuttle
I am having issues with Data Shuttle adding rows at the bottom. It seems to be skipping 20+ rows in Smartsheet when my data source doesn't have those blank rows. I did add a filter to filter out blank rows. Any suggestions?
-
Need guidance with structuring a Sheet fir UAT and launch milestones with tiered stakeholder roles
Hello Smartsheet Community, I'm in the process of developing a sheet with the intention to generate a smartsheet calendar view; The goal is to list leaders, team members, relevant milestones, dates and their specific levels of involvement (inform, communicate, etc). Currently, my setup requires adding extra rows for each…
-
Parent Row showing on multiple rows in a report
Hi, I'm currently using a sheet with information about different projects and need to show a Parent Row on all the other different "statuses" assigned to different Subtasks of that same project, I already have a formula to show the Parent based on their children, but I would appreciate any help on this issue. Attached…
-
How do I create a search tool within a sheet and referencing another sheet?
Hello everybody, I am a new user of SmartSheet and I was recently assigned a project of building a search tool within a data sheet. I got a way of doing it on Excel but I would prefer to build something similar on SmartSheet. Does anybody have any idea or how can I get to do this? Basically I have a master sheet like this…
-
Looking for a simple way to track account balance to make sure it stays above 0
I'm tyring to find a template or example for a really simple sheet that tracks money in and out to make sure that we don't go below 0. A fixed sum gets added at the beginning of each month and then each project has a 'number of items' x 'item cost' amount of expenditure at a given date and that's it. I had a version in…