Community

2

Hi!

I have a tricky formula I'm trying to calculate, but with no success so far... 

 

I have to different sheets that I'm looking on. 

Sheet1: Planning and monitoring sheet

Sheet2: Work reports


The formula challenge:

In Sheet2 our guys at the field are reporting on different predetermined projects.

5

Hi, 

I need to trigger a 'reminder' to customers when their appointment is 2 weeks out. So if today is June 1st, everyone that has an appointment on June 15th would get a reminder.

Can anyone help with a formula for that?  

Thanks!

4

Hello everyone!

I've checked this page https://www.smartsheet.com/legal/limits-policy 

it doesn't show the storage limit not the numbe of sheets limt.

I need to know this because we have hundreds of projects we were planning to put each one in a sheet but if theres a limit to sheets number maybe we

1

Hello,

 

I am attempting to upload a csv into a smartsheet plan.  I am getting about 60% of my rows imported successfully while about 40% are continuously skipped.  Some of these rows contain odd characters in various cells that are not traditional letters/numbers. I am unable to figure out why.

For

2

Hello,

I have a table where I hid Column C that has confidential information. Viewers and Editors cannot Unhide the columns of Confidential Information. This is amazing.

However, here's the kicker... If the viewer/editor Exports the smartsheet they can unhide the hidden columns.

How can I stop that

2

I have two formula questions.

 

1. I have Parent rows with a rollup formula created that takes the avg of the RYG balls of its childreen and creates a status =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green",