-
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#.
-
COUNTIFS with multiple conditions
Hi there- I have this formula built to count the number of projects completed within a certain date range: =COUNTIFS({Completion Date}, >DATE(2017, 7, 1) <= DATE(2018, 6, 30)) However, there are five different stages of a project: Completed, Under Construction, Approved, Under Investigation, and Cancelled. I would like to…