-
Apostrophe added to formula that is pushed from Zapier
We’re using a sheet for ticket tracking. Issues come in via a form, manual entry, or the Gmail Add-on. We’re using hierarchies to track To Dos as tasks. I use a simple formula to tell me if a row is a task or a parent. =COUNT(ANCESTORS()) I use the value for formatting and for accurate issue counts as I only want to count…
-
=IFERROR formula
Hi Within my project plan sheets I have 2 columns , On Time/Late and RAG. On Time / Late Column Formula =IFERROR(IF(AND([Original vs Current (days diff)]@row > 8, Status@row = "Complete", Milestones@row = "true"), "Late", IF(AND([Original vs Current (days diff)]@row <= 7, Status@row = "Complete", Milestones@row = "true"),…
-
Sheet Linking - Project sheets to single metrics sheet
Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and analysed. The information & metrics from all projects should be collected in the Metrics sheet.…
-
Is there a formula that shows ratios from two cells?
I am trying to show a ratio on my dashboard and would like to know if I could use a function to find the ratio.
-
Dashboard Sharing: Is there a way to check all the Dashboards I currently have published?
Hello, I've created a few Dashboards and published them for viewing. After viewed, I removed the publish option in order to stop anyone from acessing them. Is there a way to check all the Dashboards I currently have published? I wanted to make sure I haven't left any of them out.
-
Auto-Populate Left Stub for Schedules
Thanks to Paul Newcome, I was able to get a WBS schedule working. Now I need to create several schedules, using the WBS as the left two columns. Here is the problem - I need for all schedules to update whenever a row is added or deleted from the original WBS sheet. Simply using Cell Linking does not achieve this. Here is…
-
E-Mail Automation: send to a specific e-mail address & send to contact field
I have e-mail automation to send to a specific e-mail address when we receive a new request. Is there a way to send to that address and also copy the e-mail address that lives in a contact field? So far I can only find options for one or the other.
-
Hierarchical numbering patterns?
Anyone with experience setting up hierarchical numbering schemes? I want to add a column that is hierarchically auto-numbered such that child rows are added to the numbering scheme as increased decimal points. For example 1. Row 1 --1.1 sub item of row 1 ---1.1.1 sub item of row 1.1 ---1.1.2 sub item of row 1.1 ---1.1.3…
-
COUNTIFS function with two criteria
Hi all! I'm currently trying to count how many red entries (in the "Puri Safety" column) are in the month of June (using the "Created" column). I'm trying to use the following formula: =COUNTIFS(Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Puri Safety]:[Puri Safety], "Red") However, it returns a value of zero... what…
-
Scheduling with Fixed Capacity Resources
I need to schedule project tasks by resource availability. All of the smartsheet resource management tools appears to assume there is always a resource available for the task, so the advice is simply to schedule another resource when one is overbooked. I actually view resource availability as a constraint. Specifically, I…