-
Need Help - Can't Wrap my Head Around SS Logic
I'm trying to build a metrics table that can be used to generate a graph on a dashboard. I am a consultant and would like to track client hours from a master sheet that logs all clients, dates of services, and total hours. Let's say I wanted to track the hours of utilization from a particular client from YTD, Last Month,…
-
Best Practice - Data Integrity - Forms
When your business starts to build lots of sheets (as we have) the issue of data integrity comes into play. That is if you have lots sheets with names, or activities you can now put them into one sheet and reference to them BUT whenever you build a form and want to restrict the user selection to the defaults in the drop…
-
Hyperlinks to Password Protected Documents in One Drive
We have a shared One Drive account and I would like to create a hyperlink to certain documents that are password protected to certain users of a Smartsheet. Is it possible to do this so only those with a password can open the documents (either in Excel or PowerPoint)?
-
Listing Options in IF formula
I've looked at the forums and tried as many variations in the formula as I can think of, so I need some help. My two columns (both drop downs): Payee Name Payee Position *(location of formula) I'm trying to get Payee Position to automate the position title for each payee. Here's what I've got to work for one position…
-
Create a new row in Database2 when new text item is added to Database1
In my main project log (Database1), I have a "Customer" column with a drop-down list of all existing customer names; it is NOT restricted to drop-down values only so you are able to type in new customer names as well. I am using Database2 to assign each customer name a row to collect/sum specific data for all projects for…
-
Notification without changes in row or column
We have a sheet that track onboarding activity for new clients. Two date columns in the sheet are Follow-up Due and Follow-up Actual. I would like to send a notification or reminder to the assigned employee on the Follow-up due date if the Follow-up Actual is blank so they are only receiving notifications about open items.…
-
Skype Log in issue
When I try to sign in to Skype for Business, there will be a pop up for the sign in, but it quickly goes away and tries to do it all over again. I am using Google Chrome, and there are a few more people in our office having similar issues
-
Base rule off of 2 columns
I'm looking for a way to create a rule that would be: If Column "Status" says Funded, and Column "Fee" is blank, make the row Yellow Is there a way to do this? I can't seem to figure out how to get 2 columns on there to create the rule Thanks!
-
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!
-
Automatic 'Text Wrap' Feature in Grid View
Hello and thank you in advance for your time! One of the sheets that I use prequently has text wrapped automatically in the grid view. This has only started the last couple of days so I imagine someone in the building has changed this by mistake. I have been tasked to change it back. However, I do not know what I'm doing…
