-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
Multiple users and automated backups
If multiple users have access to the same sheets, what impact does that have on automated backups? It would not be desirable to have more than one person backing up a single smart sheet.
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Change status automatically when selecting % done
Hello I have searched through the Help centre (center!) and I can't find the formula (if one exists....) that will automatically select the appropriate value in the % done when one of 6 choices from Status is chosen. So when I select Not Started, I would like 0% to appear in the % Done, Started=25%, In progress=50%,…
-
Default Sheet Displayed when opening Smartsheet
With the old UI, the object (sheet) that was opened when we closed Smartsheet was displayed when we opened Smartsheet the next time; however, with the new UI, this seems to be hit and miss. Is there a way to set a object (sheet) to be the default when opening Smartsheet?
-
Is there a way to recover a deleted user?
Someone was termed who shouldn't have been termed and their account was deleted. Is there a way to recover a list of all the smartsheets that were shared with her or recover the smartsheets shared to her? Her owned sheets are fine as they were transferred to me but she needs access to all of the sheets that were shared to…
-
Tracking age in hours
Hello, We are using Smartsheet as a ticket queue (users submit tickets via a Form) and I'm wondering if there is a way to track age in hours as well as hours between updates. For example, if we want to show how many hours it took to assign the ticket and how many hours it spent in a particular status and things like that.…
-
The Mythological Product Development Team
Once again, I have gone in search of what I would consider a perfectly logical and necessary function only to find that Smartsheet can't accommodate. When I call customer service, I receive the same answer every time: “We don’t currently offer that function, but we will submit this to our product development team and they…
-
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…
-
Workflow and cell linking.
I have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a workflow to move cells to a new sheets but it does not seem to be working. Is this because I have the cells linked to another…