-
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…
-
Auto populate from one sheet into blank rows on another
Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill out all information on one sheet to keep things simple for them. Is there a way for me to…
-
Stripe Checkout Integration with Smartsheet Form
I have a smartsheet form collecting data for people participating in a conference. I wish to integrate it with Stripe Checkout, so that once submitted, depending on what was checked in one particular box, the Stripe Checkout payment box kicks in and takes over for ticket payment. Can this be done on smartsheet and how to?
-
Drop down list column \ multiple choice
Dear support! Could you please help me to understand if it's possible to use multiple choice in a column with drop down list? I mean that maybe there is a way to create something like that?
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…