-
Workspace Enhancement
Good morning, As our company grows, so does the workspace in smartsheet. Can I add a request to allow notifications from the workspace without having to go into individual sheets to change the automations please. I have about 40 sheets I need to add someone to and have to do this individually through all sheets. Thanks!
-
Does anyone have any great manufacturing process systems
I am always looking for some ways to improve our sheets and the overall system. i run a manufacturing company and I am looking for anyone who is will to share their flow in smartsheet. We do a rebuild every year and do a planning week to refresh our processes. It is time to do this so any shared ideas would be great.
-
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…
-
Dynamically Updating Row Information
I am looking to dynamically update add or delete a row in a sheet based on a checkbox on another sheet. Specifically, we have a sheet that contains all our outstanding balances, and a sheet that contains all our job info. We are looking to have it add a row to our balances sheet when our checkbox isn't checked, and delete…
-
Loading .jpg logo
I cannot load our jpg logo. It is readable by every other software program I use. The logo is attached to this message.
-
Sumif across Children and Grand Children
Dear Community, I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value. Here are the formulas I have been trying: SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50)) => result to #UNPARSEABLE SUMIF(CHILDREN($[Payment Status]27),…
-
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…
-
Adding together multiple COUNTIFS?
Hey everyone. I'm trying to implement a formula that will allow me to reference two ranges from one sheet and follow the specified criteria that is given to them. My most recent attempt; =COUNTIFS({Unit_Type}, "CP2 - Double", {ACCS Overall}, [T2]26) + COUNTIFS({Unit_Type}, "CP4 - Double", {ACCS Overall}, [T2]26) +…
-
Formula irregularity
Fairly new to Smartsheet, although I know my way around an Excel spreadsheet. I am trying to create a count of how many reports are submitted per hour on each given day. The reports come in via a Web Form, into the Taxi Rank Data sheet. I have created the following Sheet (see attached jpg) with the following formula,…
-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…