-
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…
-
Transferring Workspaces
I've had my intern create 168 workspaces, with each workspace containing approximately 20-50 sheets each, organized into various folders under each workspace. Each workspace also has 3-4 dashboards pulling together this information... With my intern leaving at the end of next week, what is the easiest way to bulk transfer…
-
Pre-populate Web form with info from Dashboard
Hi everyone, here is what I'm trying to do: I want to create a dashboard with links to web forms when doing on-site audits. These links will be different sections of items being audited. When I encounter an issue, I would click on the link, fill out the form and then keep going with my walk-through. These forms would be…