-
Pasting from Excel triggers an Automated Workflow
I received numerous one liner emails daily from a customer with consistent data I need to action against. I'd like to paste from Excel into a Smartsheet GRID and then a workflow be triggered to validate information and email notify the respective parties. However, when I copy and paste it doesn't trigger, what do I need to…
-
Has anyone found a workaround for DataUploader to run from shared google sheets?
We would like to set a few datauploaders to run daily from google sheets. The google sheets are owned by several different individuals/users and stored in a shared google drive. Due to Smartsheet licenses we would like one person to own the data upload workflows, but Smartsheet does not currently support Data Uploads from…
-
How to Use VLOOKUP and SUMIFS
I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, each reviewer, and then the total time spent on each case. What I would like to do is on…
-
Is there a function to have google sheets and smartsheet to have a live active link?
My company currently has two separate department that uses two different systems. My department is using Smartsheet and the other department is using Google Sheets. Is there a way for the two systems to communicate with each other with links and formulas?
-
VLOOKUP returning #INVALID REF
I am receiving the #INVALID REF error in smartsheet and I am not sure how to correct it. =VLOOKUP([PART NUMBER]1, [PN]1:[PART DESCRIPTION]1800, {2,3,4,5}, false) Below is the excel sheet formula that does work but does not flow over to the smartsheet. =VLOOKUP($Q6,$A4:$D25014,{2,3,4,5},FALSE) If you look at the excel…
-
API Demo: Creating a Formatted and Printable View of a Row
Here is a demonstration of a feature I created using SmartSheet's API. Let's say you want to print all or some content of a row. Or perhaps you want a nicely formatted and easy to read view of the row. The specific use case addressed here is to print a copy of a school library order for new materials. This print out will…
-
Sync Google Sheets & Smartsheets
Hello, I have a task board in smartsheet that my team uses to track work. We have a third part application we use to track metrics and it only integrates with google sheets. Not smartsheet. Is there a way to have smartsheet data sync to a google sheet?
-
Importing from Excel to Smartsheet (Grid) using names for contacts
I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would like them to come in (during the import) as SS contacts (name, icon, email shown and can be used…
-
Data Uploader Filtering
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formula criteria be. Incoming equals TODAY()-30 - or something similar? Screenshot attached.…
-
Converting 2020-05-20T12:38:08.063 to a date format
Hi Everyone, I am using data uploader and importing an excel file that uses this date/time format 2020-05-20T12:38:08.063. Looking for suggestions on how to extract the date efficiently. At the point of export into excel there is no option to remove the time stamp so I'm kinda stuck there. Thanks in advance !
