-
automation of checkbox or RYG balls (or something)
Good morning! I have 3 sheets that work together to serve various functions, including taking daily attendance. MASTER CAST LIST lists each person's name, SIGN IN SHEET and CONFLICT CALENDAR are driven by forms with contact formatted drop down lists. It's all the same people on each of the 3 sheets and the primary columns…
-
Can a Workspace be Deleted?
Hi, I am new to Smartsheet. Is it possible to delete a Workspace? If deleting a Workspace is possible, can I please get the steps to do this? If it is not possible to delete a Workspace, what practice(s) are users implementing for Workspaces that are no longer in use and that we no longer want to see? Thanks
-
notification
can i set a notification that is driven by a date and a name. ie i have a date column with a date range for my local school term, showing weekdays only. my next column is a recurring set of names, and finally my third column is a column titled 'tasks'. what i want SS to do is to send the person in column 2 a notification…
-
Client list in card view
Hi guys, we've been using smartsheet for about a month now. We have our client list set up in card view which is taken from my smartsheet contacts. If you hover the mouse over the contact it only shows their name and email address. Is there anyway this can come up with their phone number too? We have phone numbers set up…
-
Data privacy in community app
I'm new to the fantastic community and have a question re data privacy. When registering with my Smartheet details I was required to allow the Smartsheet Community App to "Read Sheets, including attachments and comments". I presume that this simply means that the app is allowed to verify my account, rather than that my…
-
Selective Count
I’m trying to get a count based on 3 different conditions. The formula that I have so is =countifs($[it track]$2:$status$500, “01. Reporting”, $[it track]$2:$status$500, “ Tier 1”, $[it track]$2:$status$500, “Green”) If all 3 conditions are met than a count is added. But its not working what am i missing? Thanks
-
switching accounts
I have been with my company for 9 months now, and prior to my employment that have not heard of smartsheet. I purchased Smartsheet before I was employed here and intrduced it to the company. Since then the company has seen how useful it is and wants to purchase and pay for it. How can I get the account switched over to the…
-
Fiscal year set to Feb causes year to be incorrect
My Timeline Display is set to fiscal quarters then months. e.g. Q4 FY 2018 / Dec 2018 If I set the fiscal year to start in Jan everything looks fine. If I change the fiscal year to start in Feb the calendar shows the current month as Jan 2018 and the next month to be Feb 2019 instead of Feb 2018.
-
Automating check box for multiple values
Hi, I need help writing the formula to automatically check the box when any one of these three values is selected: Complete, Cancelled, or Passed_Conditionally. Thanks!
-
Forms using drop downs
I read in an older post the when using forms you can only use values within the drop down even when "restrict to dropdown values only" is not selected. Has this been resolved yet by Smartsheet?