-
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…
-
rolling up detailed project dates up to a high level gantt chart
We create a detailed Gantt chart for each project we are working internally. I'd like to roll up that data to a higher view where I can see where we stand with each project on a single Gantt chart. Is this possible?
-
Linked Cells that are not read-only
We keep our master calendar/schedule in Smartsheet. Every year, we create a new copy of the sheet and insert dates for the new year, but the majority of the other content stays the same. Is there a way to do a cell linkage where the linked cell in the destination sheet IS editable? For example, for each row on the…