-
If, Then with a date and N/A
Hello, I'm attempting to put 3-4 arguments together. I can get 3 to work, but not the 4th. I have 3 columns: Letter Due, Letter Sent, and Sent in Window. The Yes, No, N/A are calculated for Sent in Window using the below formula =IF(AND(ISDATE([*Confirmation Letter Due*]@row), ISDATE([*Confirmation Letter Sent*]@row),…
-
Critical path viewed when linked to a parent row
It would be nice to have the critical path show when linked to a parent row. I have a parent row (e.g. Testing) where the children (e.g. test 1, test 2, test 3,...) are performed in parallel & have the same finish date, so I often link the successor task(s) to the one parent row vs. each individual test task rows (can be…
-
Used in Formula for <unknown sheet>
i see this everywhere. i know its from when i delete projects and such, they will leave this leftover trace/breadcrumb ... but why? And does this impact performance? some cells in some sheets have tons of these, so im just wondering why they dont auto remove themselves or how to easily manage those as opposed to clicking…
-
Can I write a cross-sheet formula that works if one has one and the other has many?
Here is the use case: Smartsheet A: Lists selected clients once per row (includes a column with a unique client ID). I created a drop-down column for each product with yes or no picklist. Smartsheet B: Lists clients on many rows (includes a column with a unique client ID). I developed a formula to enter "Yes" IF the the…
-
Indent/Outdent Rows not showing on Reports and Dashboards
I have a Project Schedule "Sheet" that has several parent and child rows. When I created a "Report" for this same sheet, I noticed that the parent/child rows are not showing on the "Report". For example, the report is not allowing me to see which rows are indented/outdented. It would be very helpful to have a way that the…
-
At Risk Flag
Hello All, I'm trying to enable an at risk flag with the following criteria: Within 3 days of date to follow up if the status is either "open" or "deferred" ignoring any rows that have blanks for dates I've been searching the forum, I found one that worked, but flagged every empty row at risk because there were zero…
-
Add Delete Rows that Don't Match Filter Criteria Option for DataTable
Because there is no way to delete DataTable entries from a Data Shuttle workflow, I have to abandon the use of DataTable. Because I am unable to delete entries via Data Shuttle, DataTable connections have been pushing out of date and incorrect information to my sheets. I am hoping the DataTable and Data Shuttle product…
-
COUNTIF duplicate based on 1 additional value, exclude blanks
I am essentially trying to highlight rows once there are 5 service entries submitted on a serial number using a helper checkbox column. I have tried every suggestion I saw on other questions pertaining to duplicates and blanks, but I still either get UNPARSEABLE or INCORRECT ARGUMENT. Type Column - needs to only look at…
-
Smartsheet Expert
Hello, My name is Caylee Birkel; we have a cabinet design company in Nebraska that uses Business Smartsheet everyday and need help taking our Smartsheet needs to the next level. We don't want to upgrade our plan to anything higher than our existing plan. If you feel you can be of any assistance, we would love to hear from…
-
SS Project Plan: Auto adjust start/end date based on Resource vacation time
Hi, I have a project with Work Breakdown schedule, that has tasks assigned to resources. Our PMO policy is very strict in the way resources are allocated to tasks i.e., no resource should have more than 1 task assigned to them for the/within the same duration. This also includes vacation time. Coming from MS Project, there…