-
Using a sheet to assign a project number
We use google docs currently for our company to input data about clients, and be assigned a specific project number. We have ~30 employees in the project book pulling these file numbers at any given time, so we like the transparency of seeing who is on what line, so as not to overwrite their data. We then take that project…
-
Data change before they're approved!
Hello! I'm a new smartsheet user and I've been testing it for the past 2 weeks to decide whether to use it or not. My problem today is when I send an update request to a user and set an approval request to myself, the changes made by the user get registered in the sheet before I approve the changes. So whether I approve or…
-
Form - Column data entry
I can't believe this isn't asked more often...any way of using a Form to populate data into a new column, rather than a new row? Apologies if this has been addressed previously.
-
Embed webpart in a dashboard
Would it be possible to add a webpart to a dashboard? For example, I have a custom map on my ArcGIS online account. I would like to be able to embed a map into a dashboard.
-
Multiplying Formula Issue
I am looking to multiply a simple "quantity" times the "cost each" into a third cell. I created a formula but cells that have no entries in the quantity and cost cells yet, have totals as $0.00 in this column. I played around with the IF statement but had no luck. I do not want to see a column of zeros.
-
convert a fraction to a decimal so it can be shown as a %
Is there a way to convert a fraction into a % without having to do it longhand (as in having two columns with fraction values to then present the sum with % formatting). Thanks in advance.
-
Is it possible to assign a task to multiple people?
I am running a project where certain tasks are the responsibility of small project teams. As the teams are flat in hierarchy I would like to assign tasks in my smartsheet to multiple (generally only 2 or 3) people, such that they receive reminders, update requests, notifications etc and can update the sheet. Is this…
-
Too many emails notifications for approvals and update requests
Hello Smartsheet community! I'm asking if there's a way to limit the emails received after each update is submitted through an update request and waiting for approvals? or cancel them and rely solely on the app notification? I have many tasks in each project and I set myself to approve all updates coming from update…
-
Hierarchy tagging
Greetings, I have a organizational structure that has three levels * Campaign * Project * Deliverable * Task I am trying to figure out a way how I can have a column with one of the above values that is based on hierarchy. I have the project and deliverable part figured out using the following formula:…
-
Can one web form populate different sheets
I'd like to know the following re web forms: One - Can one web form submission populate different sheets Two - Can web forms assign unique ID#.