-
Automations Between Sheets Without Formulas
I'd love to be able to change cell values in a sheet or copy/move a row of one sheet based on the value in another sheet. You can technically set up a formula to change the cell value using some kind of lookup but I'd like it to be a one time thing and then have the user edit the cell manually after. The example I have is…
-
Recover deleted important folder
Hi Team , I deleted accidentally very important folders, Please let me know if there is away to recover them
-
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…