Community

I am trying to have a RYGB call status say this:

If Due Date is today or before today & status is NOT = "complete", show ball as RED

If Due Date is tomorrow or 4 days from tomorrow & status = "Not Started", show ball as Red

If Due Date is today or greater than today & status  = "In Progress", show

Looking for guidance....I have an If statement which is creating a text value and not a numeric value, thus it won't allow me to choose those results and sum them up.   Any suggestions?

This is the If statement example I have which provides the end result number, but the value appears to be listed

Hi 

I getting trouble with my Zap.

And so fare i cant figure out the problem.

Is there a way you can help me to get this working again ?

The Smartsheet have been the same all the time, but the problem suddenly startet urly last week.

I reach put to yesterday av got this tip:

Thanks for reaching

Does anyone know a formula that will automatically count down?  I am currently using 

=DATE1-TODAY()

The problem with this is that I have to open the sheet everyday to update the count down date.

Thanks,

Hi,

I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. 

However, cs manager always change.  We have 1000 buildings.  

Admin will send update list every week.. I know there is data live

Hi, I am using =IF(AND(  ... )) to project in which month a disbursement will be made in a project planning sheet. 

Does anyone use an easier faster way of scheduling disbursements and depreciation?

I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row.

Hi,

I am unable to sheet scroll using my mouse.

Pulling the side tag works but not with mouse since today.

Any reason for this?

Rgds

Ian

I need to compare the date value that is in the Start Date or End Date to a date value that is in a text/number column.

When I compare the two, I get "#Invalid Operation."  If I change both columns to Date columns, it works, however that does not work well with my spreadsheet.

Are there any tricks

Brand new to SmartSheet.  Looking for best method for nested IF/THEN statements to provide status.  Or alternate methods.  Example... IF column N has any value, THEN column B shows Status 1, IF column O has any value, THEN column B shows Status 2, etc.  My nested IF/THEN statement from Excel didn't