-
Deactivate temporarly all "Alerts & Actions"
Hi all, i need to make some updates on my spreadsheets, that were not made on due time. But i don't want to confuse people by triggering notifications and alerts of actions already completed. Is there any way of deactivating all the "Alerts & Actions" at the same time, and then activating them again as soon as i got…
-
Counting and applying "color status" for parent/children rows
I have overall Annual goals (purple lines) with sub projects that fall into a particular category. I then have subtasks that fall under the corresponding item (identified with an alphanumeric task number). I want to be able to summarize (on a dashboard) a couple of things: the task health of the project level (task 25 with…
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Card view - How to decide the "fastview" Columns?
Hi! When you go into card view and look at a card. You see the "Main collumn" as the card name but you also see 4 more columns without going into "edit". How do I decide what columns should be shown ON the card in card view? Kind Regards// Hugo Martinwall
-
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.
-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
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…
-
Circular / Blocked Reference (Vlookup)
I have a problem with 2 sheets reading each other’s data through a VLOOKUP. The same problem was posted on May 30, 2018 by scott.barrett. Obviously it is not solved. My sheets also work perfectly for periods of time, and then start returning #circular or #blocked data without any changes to the sheets in almost every 2…
-
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…
