-
Changing the Color of a Font Based on Values
Hi All I'm building a budget sheet and am trying to figure out how to change the color of the font if it adds up to be over budget. For Example: =IF([Column]1 > [Column]2, "Red") But by doing that, it doesn't change the color, it puts in the word Red. Is there a way to do it in Conditional Formatting that I'm just missing?…
-
Are notifications still firing for the community?
Hello, over the past couple weeks I have noticed that I am no longer getting notifications from the community. Has something been updated or changed? I checked my notification settings and they are all set to send me emails when things are added. But I am no longer seeing those emails and there are no filters in my email…
-
Send email to people who fill out form at a later time
In trying to use Smart Sheet as a way to track applicants, and even use a form as an application, I'd like to be able to notify applicants that did NOT get the job that they didn't get the job. Is this even possible if I collect email addresses?
-
COUNTIF Does not equal
Hello! I'd like to set up a formula to COUNTIF(Children)<>"app/registration complete" so I don't have to setup a more complicated COUNTIFS (I allow the dropdown to not be restricted to the text options I set up). Can't seem to get it to work. Is "does not equal" possible for COUNTIF in Smartsheet? Thanks in advance!
-
Could you please provide an example of a formula to count for the last week?
Could someone please provide an example of a count during the past week? Each row has a date listed, and several rows could have the same date. How do I enter a count of all of those dates during the last week? What if I need to add if it's only a specific status? Where do I set the formula within the sheet? An empty cell…
-
New JIRA tickets don't appear in linked Smartsheet file?
I'm using the JIRA+Smartsheet connector app. I created two sample JIRA tickets and was able to get these tickets to appear in a Smartsheet file. I then created 600 new JIRA tickets and these aren't syncing to the same Smartsheet file even though the same filtering criteria should be met. Can someone help me to troubleshoot?
-
In Application Alert Notifications without email?
Now that we have the alert notification alert in the top right corner of the SS application, is it possible to have that show the alerts but to not receive an email? I'm in SS all day so I see the alerts and view them in the system and then just delete the emails they generated later. It would be nice if the delivery…
-
Engage 2017 Retrospective
Hello Smartsheet Community! I just wanted to thank all of you who attended the first ever Smartsheet user conference, ENGAGE 2017. If you weren’t able to attend the conference, but are interested in seeing the Keynote, the video is available on the Smartsheet website here. Of the highlights for me, one of the best parts…
-
Convention planning template for multiple presenters / tours each day x 1 week
Hello! I'm a newbie and have been searching for quite a while in and out of Smartsheet for a template or method on how to use SmartSheet to assist with planning a weeklong convention. The part I'm missing / stuck on is the actual events during the convention, e.g. 6 to 8 clinic rooms running simultaneously with an equal…
-
Locking columns but allowing form submissions, comments and attachments
Hi, I have a sheet I'd like to share with others, but not have them be able to directly edit the info in the columns. Instead, I'd like them to use the comments as well as use a form to submit requests. The form fields would correspond to the columns in the sheet and their submissions would appear at the bottom of the…
