-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
-
Export to Google Calendar although no longer syncing from smartsheet
Question- We would like to export the calendar to Google Calendar. I am familiar with the publish feature but it appears that it will only create a new calendar and can't be added to an existing Google Calendar. 1. Is this correct? I would like to export all entries into Google Calendar but not have it synced, meaning if I…
-
Row sorting
I use smartsheet to keep track of project stages, I have 5 stages of the lifecycle all sorted by a different color. Is there a way to organize the rows so when that stage is reached, the row automatically moves to the bottom of the next section?
-
Sales/Support Hours
I am growing increasingly frustrated with not being able to get in touch with help early in the morning (east coast). What are the hours that sales and support work? I can't find it posted on the website anywhere. Having to wait until midday to get a hold of anyone is really a pain and causing delays for my organization.
-
Not receiving notifications
Hello all... I am fairly new to Smartsheet and this Community but have come across my 1st issue. I have created a Smartsheet where multiple users will be entering data for items to be purchased through our Purchasing Dept. I have created a formula where, when the "Ordered By:" and "Ordered Date" are populated, the "Status…
-
Agendas in the meeting templates
Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions. In the dashboard, it has previous agendas and upcoming agendas... How do I get that to update to the next agenda? The first meeting I did is over, do I have to make a new form for the next meeting and link it, or can I…
-
Not receiving notifications
Hello everyone, I am fairly new to the Smartsheet app, as well as community. I am having issues with not receiving notifications, when a certain task (column) is populated. I have created a Smartsheet to order materials from outside vendors. There are to be multiple employees adding stuff to this sheet, and one or two…
-
Conditional formatting of dates
I have two columns set up, one with a arrival date and one with a start date. I want to highlight the cells in the start date column if the proposed "start date" is before the "arrival date." The purpose if to show that the activity can't start before the materials have arrived. Does smartsheet have this ability?
-
Calendars
Hi, I'm currently importing a Gantt project backup from another application to view in Smartsheet's calendar view. I wonder is thetre any way to merge several backups in one calendar view?
-
VLOOKUP reference file not being captured through end of sheet
I am having an issue with VLOOKUP. I will attempt to explain. When I set up the parameters to "reference another sheet" I capture all of the row/columns through the end of the sheet. As I add new rows to the source/reference sheet and my main sheet the VLOOKUP does not return the expected values. When I look at the…
