-
Apostrophes being added in front of numbers and column property changes to dropdown (data shuttle)
When I use Data Shuttle and I upload the source to the target, it is changing column property from text/number to a dropdown and adds an apostrophe before the number. I have 8 "discount" columns per sheet, but it only disturbs some of them. If I need to perform some calculations using those numbers, I can't. I'm not sure…
-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
-
Copy Row Automation
Hello! I have been tasked by my team's leadership to create a way that they can audit how often my colleagues are updating their project plans. We currently have a "Master Sheet" that lists all of our current projects and certain cells linked in from each project plan. The project manager is supposed to be updating their…
-
Combining/Summing Contacts from Multiple Cells in a Single Cell
Greetings, In a Contact Column, and in a ancestor/child relationship, I would like for parent rows to summarize/list all persons in the child tasks. Is Smartsheet able to perform this action? E.g. If the child records list: * John D * Claire H * Emily G I want the parent to show: * John D, Claire H, Emily G. I have tried…
-
How do I create an chart to show ongoing activity?
I use the following to surface data to illustrate submissions over time over a set period of time (set start and end date). This uses a metric sheet with the dates in one column and a function adjacent to 'look' for the same dates in my source sheet. How do I create it to capture ongoing submissions? IE no end date? How do…
-
Use INDEX COLLECT to identify Row and Column of another sheet
I have a sheet that is filled out by an individual and then when the submission is complete, it will create a unique code. I want to copy their data over to another sheet on an individual basis. Context is each week the person will fill out their form and update their results. Based on their email address and the week they…
-
Move row automation - moving to top of sheet
I have a formula that works great when a new row is added ot the top of a sheet, but if I automate moving a row from pretty much an identical sheet, it adds to the bottom...is there a way to have the Move Row automation add to the top of the destination sheet?
-
Invalid Operation when using Today() in nested IF STATEMENT
Here is the formula I am working with: =IF(ISBLANK([Start Date]@row), " ", IF(ISBLANK([Actual Start Date]@row), "Not Started", IF(ISBLANK([Actual End Date]@row), "In Progress", IF([Actual End Date]@row > TODAY(), "In Progress", "Complete")))) When I have dates entered for Start Date, Actual Start Date, and End Date the…
-
Is it best to link only one predecessor to each task or is it ok to have multiple?
I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…
-
Create Chart Widget Using a Report (not a Sheet)
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…
