-
Calculating average on linked cells - divide by zero error
I have linked 2 cells from another Smartsheet that are child tasks to my project plan. When trying to average the linked cells in the parent task, I am getting a divide by zero error. The linked cells are not showing 0 in their calculation. I'm at a loss. My project plan showing the linked cells and avg formula. I'm…
-
MULTIPLE TABS
Does smartsheet allow having multiple tabs within the same sheet? if not how can i have something similar? because i need to split my sheet in different country tabs.
-
Is there a way to attach an uploaded photo(s) to a specific column instead of the whole row?
I'm building a form that requires 13 different fields to have different photos attached to them, but I am unable to find a way to attach photo(s) to a specific column/field instead of the whole row/submission. Please let me know if this is even possible.
-
Receiving an exact copy of a form after its completed by others- how to set this up automatically?
-
trouble shooting a range
a series of references have become invalid? not sure what has caused this but i want to walk thru the formulas and make the corrections how do i see a range? i see it being called in the formula but i cant figure out how to go to the range and be sure its still valid
-
Unable to save
When sorting the active sheet and then clicking save. I received a sorry having trouble reaching Smartsheet right now.
-
How to make a report that includes only dates within the past 60 days?
When I set up my report using "is not in the last (days)" then add 59 after it, the report is considering blank dates as true. I need it to ignore blanks. I need the row to be in the report if any one of the dates is past that point. The ones that are blank are due to the person not being trained in that area.
-
Assign to group instead of person
Hello, Is there a way to assign a task to Group A instead of just picking one person at a time?
-
Approval Automation
Hi, What is the most efficient way to set up an approval automation for 30+ approvers? For example, I am building a Travel Request form, which requires approval from managers across numerous departments (over 30 departments, one manager for each department). Do I have to manually input each of these managers as an…
-
Bridge API Call Error
I'm trying to use Bridge to access the API and sort my sheet. When I run it in Postman, everything works as expected. However, when I run the command through Bridge, I get an error. Error 1004 "You are not authorized to perform this action." I am using the same token and have everything set up according to this tutorial: I…
