-
Groups dropping from Alerts
Hi everyone, Has anyone had issues with Smartsheet groups dropping off alerts that have been setup? I've had this happen 3 times now and I have to keep adding them back. Thanks for any advice.
-
Forms- Multiple guests contact informatio
Hello, We are using a form to RSVP to company events, for these events we have our team members inviting guests. The form is sent out by email to our team members and asks to provide their guest count, then we ask them to add their guest's contact info (name, company, email and phone number). The problem we have ran into,…
-
Notifications when a date is now in the past
If a date in a cell under a date column is now in the past (i.e. the date hasn't been changed, its just now in the past) if it possible to automate a notification reminder to someone to do something? All I can see in the notifications capability is the ability to send a notification if a row is actually changed or added.
-
Help Desk Dashboard
Has anyone created a Dashboard that links to a Help Desk SmartSheet? I'd like to be able to have a Dashboard that shows users the status of all tickets submitted, so that multiple tickets aren't submitted for the same issue.
-
Formula involving multiple IF/AND statements
I need to modify the following formula to include additional AND conditions. =IF(Finished12 = 1, "Blue", IF(Target12 >= TODAY(+14), "Green", IF(AND(Target12 >= TODAY(+7), Target12 < TODAY(+14, "Yellow", IF(AND(Target12 < TODAY(+7),%COMPLETE>70, "Red")))) The additional condition would be in the third if and would be…
-
System Generated Time Stamp Issue
I have a project that needs to count how many lines are added on a particular day. I found that dates convert to the next day after 7:00 pm. I've tried (=dateonly) and the date still advances after 7:00 pm. I need to be able to capture based on the true date. Does anyone have an insight into a solution? Thank you
-
RYG IF Statement Help
Hello-I am working to automate a SmartSheet for my team and have a "Status" column with RYGs (Red, Yellow, Green) which are visual assists for the status of the action item. I need help; the IF statement I created won't work. Here is what I need: IF the "Completed" column (based on a date entry) is populated with a date,…
-
Date calculation
I am trying to use an Excel date-related calculation in Smartsheet and I'm having trouble translating it into Smartsheet. Any thoughts on the situation below? Column A (Deadline) is manual entry of Deadline date - no issue there. Column B (Due in Next 60 Days) is supposed to return "TRUE" if the Deadline date in the row in…
-
Widget interaction - opening in a new tab
I have created some widgets on a dashboard, that when clicked are linked to a source data sheet. The issue is that these immediately open in the tab being used, meaning you have to navigate back to the dashboard. Is there a setting where you can click on an interaction widget and it will open the linked item in a new tab?
-
List totals
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list. For example: List A Joe Doe Freddy Mercury Alice Chains Eddie Money Joe Doe Eddie Money Joe Doe Report: Joe Doe - 3 Eddie…
