-
Workspace Column in Reports
When running reports, they are often from multiple workspaces. Each department has their own workspace with their own project plans. It would be helpful to have a column where it could pull in the workspace name where the sheet resides. Then the report could be grouped and summarized by this column to get a count of how…
-
Data Shuttle Issue
Looking to do a data shuttle and keep running into this prompt attached in the image. All the mapped data has unique names. This issue persists when trying to do a data upload. What would be causing this happen? Thanks
-
Enable Smartsheet Automations conditions to build off a Resource Management Placeholder
We have a Smartsheet Project Plan sheet connected to Resource Management through Control Center. We utilize the Placeholders (created in Account Settings in Resource Management) to assign tasks in the Project Plan when we don't yet know the individual who will be assigned to the task. Currently we have automations…
-
Showing Groups on a Smart Sheet
Hi, In my Smartsheet I have contact emails that are a part of our user base on Smartsheet. Is there a way to show the groups that User is a part of in the smartsheet? An example of what I want to do it attached. Thank you Larry
-
Search function in a form that searches the Data in the Smartsheet
New to Smartsheet. I have a form that collects information when we issue PPE to our employees. When the employee enters their employee number, I would like the form to search and display when sand if the employee has been issued PPE prior and when it was issued. This will allow us to request the old PPE (safety vests or…
-
Running total cost
I am trying to utilize a sheet for cost tracking. I have a column where the dollar amounts are being put in, how can I just have the value of the column to keep a running total?
-
How to display numbers in billion in a cell and that is linked from another cell with currency
This is my current formula for million but I need in billion. Please help thanks ="EGP " + LEFT([Total 2023]57, IF(MOD(LEN([Total 2023]57), 3) = 0, 3, MOD(LEN([Total 2023]57), 3))) + IF(LEN([Total 2023]57) > 3, "," + MID([Total 2023]57, IF(MOD(LEN([Total 2023]57), 3) = 0, 3, MOD(LEN([Total 2023]57), 3)) + 1, 3)) +…
-
Due in Days and conditional formatting question
I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column…
-
Set default timezone for Folders
I am managing about a thousand employees spanned across the US. All of these users are in 1 workspace, distributed into folders for each region. The idea is to set folder level default properties for time zone. Many times a user logs in and is defaulted to the incorrect time-zone because the laptop they're using has…