Hi!

So--I have basic formula knowledge but feels like I'm outside my wheelhouse.

All I want to do is return a specific start date based on a couple criteria:

Week (1-7, beginning 2/20/20)

Start time (morning, midday, night) Note: all morning work starts on Friday, all midday work starts on

Hi all,

We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-down and select John Doe as the main contact, but User B can't

Hi, is there a way to automatically merge rows to a google document when a new row is added?

Example: We track phone monitoring in a sheet and want them to auto-merge into the Google Doc or PDF instead of someone having to do manually.

Hi All!

I am at a loss at how to even start this design. 

I have approximately 15 tasks that occur every month on the same BUSINESS day 

I have another 5 tasks that occur on the same business day every quarter.

I would like to see this in a calendar view

Any suggestions on how to build this?

Hi All, 

I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute).

Hello everyone! 

Hoping I can get some assistance from the Gurus around here.

Currently, we have an =IF formula that looks at the Due Date of a project and:

• if the project is today, it returns THIS WEEK
• if the project was last week, it returns LAST WEEK
• if it is next week, it returns NEXT WEEK
• if it

Can anyone recommend a purpose-built portable device for scanning barcodes that could be used with the SmartSheet (i.e. not a smartphone or tablet)? We're looking for something we can use in a laboratory environment, so it should be fairly rugged, have good battery life and be designed for

Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific

I'm trying to count instances of a specific selection in a multi-select column when "Yes" is in another column.  I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out.  

This one ALMOST works, but it won't count when another value is selected in

Is this possible, only seem to be able to add one at a time, is there a way to add