-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
VLookUp and Multiple Rows.
Hi, I'm pulling two excel sheets into SmartSheet. Sheet 1 is called the MASTERLIST Sheet 2 is Called the SALESFORM. The SALESFORM pulls data from the MASTERLIST. What I want to happen is in the SALESFORM I enter an Item Number that is in the MASTERLIST and data from that row fills in in the specific spots. Example. Item…
-
Nested IF or MATCH or JOIN+MATCH ?
Dear Community, I am trying to retrieve the information of one cell depending on several criteria: - Match week number from a date with Week Column to retrieve the payment amount - Prioritize between 2 dates (though between 2 week numbers) which one will be retrieved (Actual Payment Week will have priority over Expected…
-
Drag and drop from Google Photos
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.
-
Locked rows not picked up by automations
Hi all, I have a spreadsheet with just 4 columns, and i have a set of rules to apply to them. One of those rules is sending Update requests if the date column is over 7days in the past. But, since the spreadsheet will have "countless" rows, i want the rows that had Update requests before, to be locked (easy part) after the…
-
Pull account name from another sheet???
Hello, I need help with the following. I am buildig a sales pipeline tracker. On one sheet I have a list of master accounts. On the tracker sheet I have a column named account list. Can I do a lookup/dropdown to get the account names from the other sheet? I want to ensure the account names are typed correctly by doing a…
-
Printing Dashboards loses all the color
I have a very nice dashboard created with lots of color separators to make it east to read. But when I print it, all the color goes away and the fields I created are not showing up. Why is that?
-
Notifications not working?
Hi, I have set up notifications on my Smartsheet for our Ordering Process. The notifications act as Order Confirmations to Customers to give them details of the Order being processed and Despatch details. Over the last couple of days, these notifications have stopped sending out. I have checked the settings of each…
-
Using COUNTIF to determine quantity of rows with number not ending is 000
Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchase order and have a hierarchy themselves. The numbers that are considered the parent end in 000 with all the items that are children end in various numbers in increments…
-
Update Request to Multiple Recipients
I send an update request to 10 people. The request has the 10 recipients listed with text boxes under their names where they will each fill in data and SUBMIT it back to the SmartSheet. It works fine except when recipients go on vacation or are not available to answer the email update request. This holds up the entire…