-
CountIFS OR with more than one range
Hi, I am running into some trouble trying to add an OR to a fairly complex CountIFs function. I have tried placing the OR at multiple points, but either get unparseable or invalid operation errors. Here is one attempt: =COUNTIFS({Range 1}, "Color", {Range 2}, NOT(ISBLANK(@cell)), OR {Range 3}, NOT(ISBLANK(@cell)), {Range…
-
Using a datafile to 'autofil' cells
Was wondering if there was a way to upload a external data file (csv) and get it populate cells. IE - Could I load a list of 'Stakeholders' (make it a dropdown list) - and based on that selection from that dropdown list, it automatically fills in another cell, with lets say that 'Stakeholders Manager' So basically 1 cell…
-
Linking to a sheet from a report
I have a report that pulls task from several different sheets. I want to create a link on the report so that I can easily click on the task and it will take me specifically to that sheet that the report is pulling from.
-
% Complete not properly rolling up
Hello All, I am building out a Gantt chart and I have up to three levels of parent rows, with associated child rows, and the sub-parent and child rows are rolling up in their sections, but that isn't rolling up to the next level or the high level. Any thoughts on how I can fix the associations so that % Complete rolls all…
-
Reference to other sheets not changing in countifs when saving folders as new
Hi. I have a smartsheet setup with multiple countifs to other sheets - all within the same workspace. When I save the workspace as new, the references are not changing to the newly created sheets even though I have selected 'Newly created sheets' in the any reports, dashboards, sheet hyperlinks and cell links will refer…
-
Highlight next date
I can't find a way to conditionally format a date field to highlight the closest dates only. For example, if sheet has: 08/30/2018 08/30/2018 09/04/2018 09/04/2018 09/13/2018 I want to automatically highlight the 8/30 dates. They will fall off the sheet after the 30th, so then the sheet should highlight 09/04 rows. Is…
-
Gmail add on
Suddenly this morning, I am unable to save my emails to Smartsheet rows via Gmail integration. Anyone else having this issue?
-
SmartSheet meeting Tracker
I am looking to see if someone knows of any templates for a meeting tracker. Basically what it would do is we would have a Directors meeting. it would track all the attendes. From that Directors meeting we would set a deadline for those Directors to have a Departmental meeting. We would also keep notes of some thing within…
-
Link to excel file on our network
Is there a way to link to an external excel file without having to upload?
-
=Min(Children()) not consistently updating for parent row
I am trying to create a column of "Next Action" which will have a date for each row that is manually updated continuously. I want the value of this column for the parent rows to update according to the next/oldest date (whether the furthest in the past, or the closest in the future) of the respective children rows. I have…
