I am trying to populate a "modified (Date) cell with today's date and time stamp (date only needed) only after populating a dropdown cell with data (non-blank). I've tried NOT(ISBLANK), but to no avail. The dropdown cell is used as a status cell indicating i.e., "complete", "needs follow-up", etc.

I have an issue where the current formula feeds into the report correctly and displays on the dashboard widget however, I have now been asked to change the formula to be date specific. I need to have this display by our fiscal year (July 1, 2018-June 30, 2019). Pro-desk gave me the formula to copy

Good Morning!

I am trying to create a graph based on the current month's turnaround times.  I tried the following, but it returns as #Unparseable. 

=COUNTIFS({Turnaround}, <=3, {Date Fufilled}, Value(@cell) = Month(Today))

Is this even possible? 

Thanks

How can I lock details in the calendar app, so users can't change the data but only view it?

I am trying to flag contracts needing renewals. What am I doing wrong?

=IF(OR([Contract end date]1 <= Today1 + 1 - 90, 1, 0))

Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? 

I  know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.

I have an employee getting notifications for everybodys changes but he only wants emails sent to him that involve his changes. Is this possible?

Hello, 

I'm trying to update Dashboards using the JAVA API and in the documentation on-line, the Example Code says "todo"...    Can someone please provide the correct usage of the updateSight() method.

Thanks, 

T...

Good Afternoon, I wanted to check to see if there are any users in the Property & Casualty Insurance Industry and if so, could you share what you are using it for? I am a new user and still learning all its capabilities. I see that there is a large Healthcare following but not sure about the P&C

I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. 

I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form?  I