Mike Wilday’s Profile

Community member since February 2017

points
8910
Company
Los Angeles Pacific University
Department
IT & Operations
About Me
Skilled with SmartSheets reporting, formulas, cell-linking, sheet setup, etc. Email: [email protected]

1

HI,

 

I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users.

 

Before we signed up to the paid account this was an option.

 

Thanks,

 

David

2

Hi there!

I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox. 

The issue I'm having is that the

1

Hello, 

I am trying to create an IF(AND) statement, but I cannot figure it out.  Any help would be greatly appreciated.

I am trying to write a formula that will check the "at risk" if the the "done" column is not checked and the due date is 7 days before today.

8

Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF/AND function, but I keep getting errors when I