-
Not Counting Blank cells in Checkbox formula
Hi All, desperately need your help on this one. I've been searching the forums and tried this formula so many different ways and cannot get it to work. :( I have checkbox formula that is simple enough, I want it to check the box if we met the delivery date that was planned. So I'm comparing delivery date planned vs.…
-
Enable Confirmation Email: Add Asterisk
In order to continue the good work you've done on Forms UX, I suggest that when a user checks "Send me a copy of my responses," the form's subsequent "Email address" field label could be followed by a red asterisk, similar to all other required fields on the form. The client-side error-checking is nice with its red border…
-
Gantt zoom to current day (centered) on open?
Hello, Is there a setting to set the current day to be centered in the gantt view when I open my sheet? I always have to scroll over to the current day on long projects. Thanks, Phil
-
Need to transfer file ownership - Smartsheet won't let me!
Hello, I created a draft version of a workspace, now I need to transfer it to a licensed user and I get: "You have exceeded the maximum number of emails that your account can send" How can I get this fixed???? Thanks Karen
-
Can approvers of Smartsheet forms be added without giving access to the sheet?
I am creating a form in Smarthsheet that will require two levels of approval is a particular question is answered in a certain way. In the form they manually enter the email address of the people who are required for approval. I am finding that if I do not share the sheet with the person I am seeking approval from I cannot…
-
Dashboard and Metrics
I'm trying to figure out the best way to pull only proposed or active projects from our All PMO project lists and creating a dashboard. Based on the only active or proposed projects ....I need to pull data that shows the project type, approval status, departments, etc...
-
ISBLANK Formula
Hello,l Im using a simple formula to divide 2 cells, however the forula is showing its dividing by zero in every single cell so im attempting to use an ISBLANK formula so that the formula does not show. See the screenshot below. My forumula is originally.... =[Current Presale Total]8 / [Week in Presales]8 Then i tried...…
-
Automated Emails for Workflows - too many
I have set up the workflows (LOVE THEM) But... we are getting too many emails. One for the approval. then you get an email stating what you just approved. This in a world of too many emails. How can we stop the extra email notification? I unchecked the box on the personal settings - but all that did was not give ANY email…
-
Standard Milestone Names
I am creating a project template for my department to use for all projects. I have created drop menus to limit certain column entries to a controlled list of choices. I would like to do something similar to control how the user names a milestone. Is there a way to have a list of standard milestone names for the user to…
-
Bug: Formula not accurate for Viewer Only
Didn't see an official bug report page, so I hope it's OK here. I've built a formula for a parent row to count orbs in children rows and display red > yellow > green, so if at least one red, the parent shows red, if at least one yellow, parent shows yellow. =IF(COUNTIF(CHILDREN(Progress@row), "Red") > 0, "Red",…
