-
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…
-
Adding information to templates
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year. My current plan, was to create a Template, then have a sheet for each person. This way I can request them to…
-
Having dates change by being linked to previous dates
Hello all, Ive looked and cant find this one ( or i didnt type the right thing in search ). I have several deployemnet dates set. Im wondering if I can have all dates change if I change one above them, EXAMPLE: On 03/14/17 I have a deployment scheduled. On 03/21/17 I have a deployment scheduled. On 03/27/17 I have a…
-
% Complete versus % Planned
Hi! I am trying to have two columns in my sheet: The original "% Complete" one and a "% Planned" one. It will help me check if my projects health is ok, by meaning if its percentage is above, equal or under the percentage of the project that was estimated for that date. I tried inserting a regular text/number column with %…
-
Task Name data not available from SSIS odbc connection
I have developed an SSIS package to read Smartsheet data, and then export the data into SQL database. I managed to export the data but noticed the Task Name, % Complete, Status fields are returning NULL values. This doesn't make sense because these fields are populated with data on Smartsheet. Please assist.
-
"Red" traffic light disappeared
Hi there, I'm currently using a "Red/Yellow/Green" traffic light status in one of my sheets, with the colour that is displayed being based on certain criteria. I've just noticed that the "Red" symbol does not show when it should (it was working fine before; "yellow" & "green" are still working ok.) I have not changed the…