-
Backwards Scheduling
I've done some research, so I'm pretty sure I already know the answer. I have a project with a hard completion date. I would like to have any subtask scheduled backward from the completion date. Can that be done in Smartsheet?
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
SUMIFS Formula won't compile
Hey there community! I have been working on this formula for a few days now and it just won't fly. I think the "<>Closed" is what is throwing it off? I have tried all sorts of varieties of syntax (<>"Closed", =2019,="2019",) - and it wont fly. Here is what I have now. Please see screen shot as well. =SUMIFS([$USD - Sales…
-
How to loop through workflow
I'm having a problem creating an approval flow. When the approver denies the flow, it automatically sends an email to the one who requested the approval asking him to clear the wrong field. I need that after the field is arranged the system understands that it should again send an email for approval. I do not want to…
-
Content from Engage 2019 Keynote speech
I am working on a presentation for our exec team about my experience out at Engage 2019. Does anyone remember the name of the company that spoke during the keynote speech about how they used Smartsheet to get resources organized & on the ground faster during Hurricane Dorian?
-
Checking Done for multiple cells
Hi! I am trying to find a formula to check a box Done when several other cells are checked done. Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done. My If Then formula doesn't seem to work. Any thoughts? =IF([Column2]1 = "Done", 1, 0)
-
Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
-
Rant about feature releases
Hi smartsheet community...I have been a smartsheet user for over a year. I have to rant a little bit. Indulge me if you wish, ignore me if you would like..but I had to get this off my chest... Does anyone else feel like the new features that came out of engage19 were a total dud? I think the most useful thing that came out…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
-
Community Login is very random and troublesome
When I go from SmartSheet to the community to see great ideas, it always asks me to login to post comments or see details. So I hit Login, then it takes me to my smartsheet page that was open. Then when I go back to the community forum, it says to login. And on and on. With a few different clicks it finally seems to work,…
