-
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…
-
Help Needed: Creating more efficient ways to update sheets
Hello, I am working on providing dashboards for my seniors. Here is the premise: I have multiple project managers (PMs) that work with four different agencies. Each PM has their own assigned sheet and assign an agency to the project. To create a dynamic dashboard, I am using a separate sheet (a table sheet) that pulls info…
-
Non-Licensed users unable to attach documents to sheets
Hi All, I have a customer who uses one of my sheets to track project progress. They were able to attach and download documents until recently. They have been running into issues doing both recently. Has anybody ran into this issue before? Any ideas?
-
Formula assistance, please
Good afternoon, I'm not even sure this can be done, but I'm giving it a shot. The picture below is a snip of the sheet I'm working on. I'm wanting to figure out if there's a formula that will put the data from a single cell on the Sep row to the "Current Month" row - but the catch is that is needs to look for the last…
-
Adding New Rows
Hi, When adding a new row, I cant figure out the rule for indenting. Sometimes it will be correctly indented the same as the row above it. Sometimes it will add new row as a "Parent" and then automatically make everything below it the "Children" Is this caused by the way I'm inserting, or is there a default setting to make…
