-
Number Positioning/Formatting on a dashboard
Is number positioning/formatting available on bar graphs in a dasboard?....any chart? My numbers all overlap and I can't figure out how to clean it up.
-
Live data in smartsheet
Trying to pull data out of our ERP (epicor) probably .csv format and keep it continuously updated to avoid manual data entry as much as possible. any ideas about how to do this? i am trying to use the data uploader but keep getting this error message. Thank you for any help in advance.
-
Creating Summary on the Fly
This may be a dumb question but I have a sheet Orders that is auto-updated every morning via the Data Uploader. So the list of items changes on a daily basis... sometimes the same items are listed and sometimes new items are listed as well. Is there a way I can create a summary sheet or grouping of duplicate items and…
-
Nested Formulas
I am attempting to use the nesting formulas to auto generate text showing the status of a project step that is co-dependent on several previous steps, but only when the previous steps have been selected. For instance,we have an "Assigned" column which is just a check box, a column which indicates if that task is complete…
-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
#Unparseable Error When attempting to use IF function
Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions. For some reason I keep getting the #Unparseable error when I type out this formula. =IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress]) I have attached a screenshot of the…
-
Workflow Approval
Being new to smartsheet but an experienced systems developer I had set up a multi person approval for capital requests in smart sheet. It was quite ugly and ungainly and smartsheet was lacking features I have used in other systems. So I was very please to see the workflow approval functionality released which goes someway…
-
Removing Multiple Link
I have created and tested a few examples of the master sheet where it links data from two base sheets. The bases sheets are maintained by my team and I don't require any changes. I have successfully done so but due to me testing a few times, the bases sheets are showing, each cell, data is outbound linked to <unknown…
-
Calculating Totals
Dear all I deal with importing goods from all over the world, and payment usually happens in multiple currencies. In smartsheet, I have a column for currency (USD/Euro etc) and the next column I have the amount. What I am looking for is a payable total in each currency, E.G. For Payable euro, the formula will look at all…