-
Which formula to use to set conditional rules between 3 columns in a sheet?
Using formulae in sheets, I am trying to create a template for Stakeholder mapping by embedding the below conditions and results. For Instance If (1) is entered in Column A and (B) is entered in column B, column C should pull in "Keep Informed". Or if (2) is entered in column A and (C) is entered in column B, column C…
-
Create a report from multiple sheet but with row as Columns
hi Friends, I am trying to make my Smartsheet work better for my user. the problem that I am facing id the following My Workspace is build in the following way. Each of our project have a specific folder name let say Project1 , Project 2, Project 3 In each of that folder we have many many files, one of them there is a…
-
Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…
-
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?
