-
pulling data from multiple columns at once
I have a master equipment sheet with different projects on it. I'm using a form to collect the information from the lightest orange fields because it's the easiest option for my auditors to use when they're in the field. I would like to get that information back to the original sheet. I know I can use an INDEX/MATCH…
-
Can I use a workflow to add a Funtion into a column based on other columns data?
This idea is to pull text from one column to another; examplet Below Primary Column: Country Names Child Primary Column: Secondary Project Workflow 1: When a new row is added, place formula to pull text from Child row into new column Workflow 2: When new column is added, place formula to pull data from Parent row into new…
-
Merged: Filters on Reports
This discussion has been merged.
-
Can Smartsheet auto save immediately instead of after 1 min of inactivity?
Hi, My company is currently using Smartsheet for Onboarding tracking and workload. There are 10+ people working on the sheet and I wanted to know if there is a more immediate process to have the sheet auto save instead of saving after 1min of inactivity, that way everyone can see what is being worked on in real time?
-
Auto sort
Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that could be 2 days from the day entered or 12 months from the day entered. We also have a filter to hide past dates. Data is being entered via form…
-
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…
