-
Need help with an IF Statements with multiple ORs and an AND
Hi. I need to write an IF statement where if the Review column has one of the following: Review Complete, Reviewed - Not applicable, Do not include, Reviewed - Not applicable, send feedback AND the COMM Review column has the following: COMM Review Complete If both the Review Column has one of the 3 options AND the COMM…
-
Metric Widget is referencing sheet that has met the 500,000 cell limit - What do I do?
I have a dashboard widget that is referencing a sheet that recently met the 500,000 cell/row limit. I thought breaking out my sheets by year would be enough space, but I was wrong. Is there a way to keep the look and feel of my dashboard widget, but have it reference 2 sheets (or something like that)? Thanks, John Stanik
-
Global contact list
Our company has many logins to use smartsheet, but we want to have the same contact list when adding names to a contact field on smartsheet. For example, when I add a contact to a contact field on a sheet, I can select from a list of contacts that only I have added (see image). If another staff member goes to that sheet,…
-
Average based on 1 criteria
I'm sure this is user error but I'm trying to average out compensation based on the job code then I'd like to create either a data mesh or vlookup to fill in the blank compensation with these averages. I've tried having a seperate sheet that has the job codes and then I'm trying to use the averageif formula. However I keep…
-
Can I auto populate values in a coumn?
Hi, I have 10 sheets built in the same way: pre filled with many information. Each sheet will be used by many team members. But I need the team to be able to add rows in that sheet. I have 4 columns that I would like to keep locked. What happens now is when a row is added the Complexity & Country column stay empty - which…
-
Making an order request form but need the ability for multiple items entered into the same order
I work at a manufacturing company, and I am creating a request form for our parts department. The way it is intended to work, is our Maintenance Technicians fill out a form with basic information (their name, part number, priority level etc.). This form notifies the parts department to check into the order and then sends…
-
Auto-numbering on one sheet based off Customer
I want to have one intake sheet that auto-numbers based on a customer. Example: ABC Company and DEF Company - I submit a new project using a blueprint and I want them to be labeled ABC-0001 and DEF-0001 on the same intake sheet automatically. Is this possible?
-
Pull data from a source sheet to a destination sheet with one condition
Hi there. I have an issue and I would like your help please! You can find below the Smartsheet I have: I have a 1st Smartsheet "Source Smartsheet". In this Smartsheet, I have a list of projects with one line per project and multiple columns that are used to save the data for each project. I have one unique ID per project…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…