-
Specific Dates in Columns
Hello, I have a column that users must input a date that their project will attend a specific meeting. This meeting only happens on set days every month, so I am wondering if there is a way to only allow a user to choose/put a specified date in the cell for that meeting. For example, if that meeting happens on August 9th…
-
Sending updates
Good morning, i am trying to send some updates on smartsheet to users that i have as my contacts, but they are getting the notifications about 30 minutes to 45 later. is there anything i could do to fix this?
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
-
Formula to include a specific range and all new entries
Hi, I have a formula as per below and I want it to start calculating from row 6 to the bottom and include all new entries. Can you please help me? =SUMIF([1 - BT]6:[1 - BT]44, "KS", [1 - # of BT]6:[1 - # of BT]44)
-
Auto attach emails to Comments on my Smartsheet
Something that would be very helpful is to have a way to automatically attach an email received in Gmail or Outlook to a Smartsheet row by inserting the email into the comments column. The email could reference the sheet and specific row by searching for an existing primary key or some other field on the sheet. Yes, but…
-
AUTOMATIC Weekly Reminders
I've created a Meeting Agenda sheet that will be used during our weekly meetings. I'd like everyone shared to that sheet to receive a weekly reminder. How can I set this up to automatically send out?
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
SUM between Sheet 1 & 2 for Time range
Hi everyone, I'm stuck and need a little help. I'm trying to group Time ranges either both columns "A & B" if doable, or just column "A" into multiple 3-Hours bucket for the day with =FLOOR or similar and pick the highest number of Customers from same bucket/ time window of 3-hours with =LARGE from Sheet 1 & Sheet 2 then…
-
Card View - Selecting View By Lanes
I want to select a certain column from my sheet to be the "view by" lanes. I only have a choice of a handful of columns, none of which are very useful to me. The column I want is available to add to each card via "fields" but not in the "View by" selection. The columns I want either contains an equation/calculation and or…
-
Combining Data from Multiple Sheets in a Sight
My team and I are having a problem with the combination of data from multiple sheets showing up in our sight. Originally, we had a couple sheets that all had formulas returning data at the top of each sheet. I then cell linked the cells from these sheets to allow one sheet to add them all together. This then allowed just…
