-
How can I edit a formula reference across all projects using Global Update?
I just did a global update to add two new columns to one of the sheets in my projects. Both columns included a vlookup. The columns came through fine, but the formulas aren't working because I used the reference "New Individual Rates Range 1" which already existed in my sheet. The original reference only evaluated the…
-
Creating a formula for metrics sheet with multi-selection dropdown
Hi all, I am creating a metrics sheet, and am having trouble creating a formula to count how many cells of a specific variable (call it "Zone") has multiple selections. I've already counted the ones where only one zone is selected but, but am missing the counts for those remaining with multiple zones selected (can call…
-
Modified by cell-link@smartsheet.com
Sometimes "Modified by" is captured as cell-link@smartsheet.com ?? we are having formula columns based on modified by column, if randomly smartsheet captures it as cell-link@smartsheet.com, all the calculations are going wrong,...pls advise.
-
Help with ROI Calc
Hi All I need to calculate the ROI on projects with savings and the below formula is working correctly when projects have a cost and saving. =([Expected cost savings in 1st 12 months]@row - [Total project costs]@row ) / [Total project costs]@row However, some project have no cost, or no savings or both and these return…
-
Looking to summarize data from multiple rows to multiple columns so I can generate a document.
I have taken over employee attendance tracking at work. I create new rows in a sheet that supervisors go in and confirm time. The columns for that sheet are in the first photo. Each occurrence is captured in a new row. The issue is, I need to be able to generate a document and cannot do that for more than one row. So I am…
-
Formula to indicate which quarter the Project's end date is in ...
… I had a formula that was working before July 1, but now "Incorrect Argument Set". :( The purpose of this formula is to indicate where the project's end date is in the Past Quarter (one quarter behind the current quarter), the Current Quarter (the end date occurs within the current quarter we're in), and the Next Quarter…
-
Trying to list distinct values from another sheet with a certain status
I am trying to list out distinct values from a separate sheet that are not marked as canceled. I am using this formula, and I only see a blank cell, even though the source sheet is populated. =IFERROR(INDEX(DISTINCT(COLLECT({Drug Name}, {Project Status}, @cell <> "Canceled")), [Primary Column]@row ), "")
-
I need to split a table
The rows I have: Serial, Issue 1, Issue 2, Issue 3 1 , A, B, C The result table I want: Serial, Issue, open… 1, A, yes 1, B, yes 1, C, yes How do I split this table?
-
Can you write a formula to Match the row id?
I am trying to use the Row ID numbers for a formula but can't figure out if that is possible. Do I need a helper column?
-
Count Date Once, Ignore Duplicates
I am pulling data from a time report. I want to identify how many days (through the Date column), someone (individual sheet) was in the Office (one of the allocations in the Location column drop-down list). Each day may have several rows related to one date, as there is a variety of allocations under the Department and…