Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2017 Posts
Archives for May 2017
Discussion List
Contact validation in Web Forms
I have a web form for users who do not have access to the full Smartsheet. Part of the web form is an entry for a contact who has access to Smartsheet. I have alerts built into this list based on specific rules. The users of the web form sometimes mispell the contact name. The contact then does not receive the…
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…
in cell comment and comment grouping
hi, in cell commenting would really enhance this product and really is a must have when managing large sheets. ultimately the row comment button could be the aggregation of all of the rows specific cell comments. if you take this step and i hope you do, you might want to consider multi cell comment grouping. so,…
gmail group mail or distribution list doesn't work in assigned to.
Hi Smartsheet Team, We have group mail via gmail in our company. Im using it to Assigned To contact list to notify them all for any changes. But unfortunately it doesn't work. What could be the problem. Smartsheet Group does not appear in Assigned to as well.Â
How to count a text in a column?
Hey there, I'm trying to count a specific initials in a column with multi initials in each cell, but it doesn't work. Please check out the image. Is that a limitation? Thanks.
Filtered Views
Is there a way to share only filtered views. I'd like the user to only be able to see and view specific rows.
Counting rows between two sets of dates
Hi Smartsheet Community, I'm trying to figure out how to count a row if the date column falls between a set of dates. Basically, I'd like to use the COUNTIF formula and count the row if the date is between 07/01/17-09/30/17. Any ideas on how to do this? I'd rather not add in an additional check box, just base the formula…
moving info between sheets
Not sure if I am missing something something but if I copy activities from one sheet to another that have predecessors the predecessors do not transfer and so I have lost all my relationships. Is this real or am I doing something wrong?
Combine 2 IF formulas
Hi, Can someone help me with combining these 2 formulas? =IF(MONTH([Date Raised]12) = MONTH([Date Raised]1), "Yes", "No") and =IF(YEAR([Date Raised]12) = YEAR([Date Raised]1), "Yes", "No") Regards, Samad
Task names in Gantt are gone
I was updating my sheet yesterday and payed no attention but this morning I've noticed that all of the task names on the Gantt chart are gone and I can't seem to find a way to get them back. Any ideas? Thank you in advance!