-
Combining IF/IF AND Statements
Hello! I cannot seem to figure out how to put together two working IF and IF(AND...) statements. ThankĀ you for any direction on how to accomplish. Sandy If I put "IF(AND..." in front of all the IF statements, only my first two statements work. The rest are ignored. If I remove the "(AND..." from only the first twoā¦
-
Export the smartsheet to microsoft project
I tried to export my smartsheet to Microsoft project and save the file there. But I did not find export button. For the trial user, do I have access to this function?Ā
-
Passing values from a report
I'm trying to create a Sight that shows a high-level overview of a portfolio of projects. If the user clicks in the widget within the Sight I'd like them to go to a more detailed report on the project that they selected but only the project they selected - not all the projects in the sheet. Is this possible? Thinking ofā¦
-
Switching from licensed user to regular collaborator
We have a licensed user who no longer needs this level of access, so I want to switch her to the regular collaborator. If I do this will this effect any of her sheets that she created until the license user level? Or will she retain all of these and then just be limited as she moves forward? Thanks
-
IF statement help to determine active sprint
Hi all -- just starting to build a library of IF statements... Looking for some help to build an IF statement to determine which Sprint is the current active sprint... Basically, IF Today's date is betweenĀ [ColumnSprintStartDate] and [ColumnSprintEndDate] then check the box, if the date is not between those, then leave itā¦
-
Non-reproducible oddities with Save As for Notifications
During my testing of the recent (2017-09-14) release: "Existing Notifications can now be included when choosing to Save as New or Save as Template." I have observed some oddities that are not reproducible, but have occurred more than once during my testing. I'm testing on a workspace with 10 sheets, oneĀ of which has twoā¦
-
Basic Project Management Suite Template
Everyone, I am in the process of creating a set of sheets, sights, and reports to manage the projects for our team. We don't need anything fancy or complicated, just something that will allow us to track our project tasks, project charter information, and a project dashboard. It occurred to me that someone in the communityā¦
-
Predecessors
I have Task A with a fixed start/stop dates I have Task B with a fixed Start/Stop date I have Task C that needs to Start the same as Task A, but finish the same as the Stop of Task B. There are multiple lines available in Smartsheet to add predecessors to a single task. In my example, Task C shows the correct Finish withā¦
-
Filer changes after 8:00PM
Hello, I noticed when I am sorting a date filter by today it will work fine until about 8:00PM. Then the filter switches date to the next day for some reason. So if today's date is 8/16 and then when 8:00PM comes by it will switch the date to 8/17.Ā I will have to change my filter to yesterday to pull up all my data forā¦
-
Sorting in the Smartsheet Mobile App
Hello, I was wondering if the functionality for sorting was available on the Smartsheet mobile app. I don't see anything like it when I am in the app so I wanted to know if it was there and I did not see it. Thanks!