-
Pasting Data Set
Hi, I have a large data set that I paste into Smartsheet from excel for a Dashboard to populate. When I paste some of the data in that's in 1 cell in excel Smartsheet is splitting it across multiple columns meaning I manually have to amend the data for those rows which is very time consuming.
-
Dropdown in Report
Hi Everyone, I have a sheet with a dropdown column. I have created a report and I want the team to update the data from the report instead of the sheet as the sheet has over 500 rows and data has to be updated in some specific rows. But the dropdown option is not available in report. Am I missing something or is it not…
-
automation with clock timer
Hello , Date column is not enough for automation updates/approvals and reminders , we need to send it conditioned on time formula ( clock ) . For example like to insert task time and and to create automated reminder / update or approval request that with condition based on time , like if the time is 1,2, 3 hours is less…
-
Static Date/Time Stamp
I've looked around and I realize that this is a feature many people want within smartsheet. I was wondering if anyone has a workaround for this. I want to automate the start date to today but I don't want it to change so using =TODAY () won't work. The sheet that I'm trying to implement this in also uses a form to input…
-
Populating external Reports with Smartsheet Data
Hi, Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document) Thanks in advance, Scott
-
Look up and sum costs of selected features
I am building a form and associated sheet/workflows to track requests for vehicles from our customers. I'm hoping to find a formula that would allow me to use features chosen in multi-select columns to look at a different sheet where the costs of each feature are organized, and return the total cost of all the features…
-
Formula not working as in instructions.
I am trying to follow the instructions on the SUMIF formula page. I created a sheet with only the "Sold Date" and the "Transaction Total" columns, entered some data, and I copied the formula "=SUMIF([Sold Date]1:[Sold Date]3, MONTH(@cell) = 2, [Transaction Total]1:[Transaction Total]3)" and pasted into a Summary Sheet…
-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
VLOOKUP and Large returning Correct value but wrong Description
I have the VLOOKUP set up but it’s returning the wrong result. For example: According to the Large function, 6,990 is the amount that we’ve spent the 5th most on so far this year, when I scroll through and find that total, it’s the Sidelaster Conversion that show's we've spent 6,990, however it comes back as the BDF Boxtoe…
-
Vlookup with Large formula as the search value
SOLVED* REALIZED THAT I HAD AN EXTRA ) IN MY FORMULA!!! Hello everyone, I have a list of items that pull from other sheets what we're spending on each one. From there, I have used the large function in a cell to pull the largest totals and rank them from 1 to 5 for a "top 5 spender list" I would now like to pair up what…