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 li…
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 CO…
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 k…
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 s…
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…
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 t…
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 (the…
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-00…
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 o…
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 integ…