-
Circular Reference / In Excel it works / SOLVED
This has been solved now :) Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. Saves some 30+people now a lot of work. Hi there, we are stuck transforming some sheets…
-
Auto-fill an overwrite-able value
Hi Community, I have a worksheet with a column (let's call it "FPD Factor") for calculating how many files can be scanned per day by a process. I would like for every new record created to have that column auto-populated with "70,000", but want it to be overwrite-able by someone. I plan to use the FPD Factor value in a…
-
De-Scoping/Deactivating Rows
We need a function where users can de-scope rows, thus deactivating that row and removing its influence on its parent rows. Is that an option via Smartsheet?
-
countifs formula help
I am trying to Count # of tasks if the task meets multiple criteria. For example, the task is green, it happened in the 2 quarter and it's in the metrics workstream. I get an Invalid Ref error in the formula. I am only counting tasks from the same sheet. Formula is below: =COUNTIFS({Health}, "Red", {Quarter}, "Q2",…
-
IF(AND( and IF(OR(
Hi All! I feel like I have been reviewing every community post about the IF(AND and IF(OR statements within a function but still can't seem to figure out what I am doing wrong. =IF(AND([Resolution Method]3 = "ClinOps F/U", [ClinOps Resolution Description]3 = "", IF(OR([Additional ClinOps F/U Needed?]3 = "Y", "Yes", ""))))…
-
Date filled in from selecting a checkbox
Community, I want a date to be filled in when I select a checkbox. I came up with the following formula but supplies the current date. I want the date cell to show the date that the checkbox was checked. So for example, if I selected the checkbox on 09/01/19 the date column would display 09/01/19 even though the day I'm…
-
Auto-generate date/time field data based upon existing column
I have a sheet where I have a Status column. When I chose "complete" in that Status column, ideally I'd like to have another column (let's say it is named "Completion Date/Time") to auto-populate with the date/time (preferably just time) that "complete" was chosen from the Status column. This seems like an easy ask, but…
-
get list of projects worked within last month (without helper fields)
I have a task list that includes what project the task belongs to. The project field is filled in manually (not a preexisting list). I would like to setup a dashboard to show a distinct list of projects that had been worked on, how much time was spent on them, etc. Where I am having trouble is how do I get a distinct list…
-
Use of Attachment Columns in IF Formula
Hi All, Is it possible to use the default attachment column while creating conditions for a IF formula ? Eg. If the row has an attachment then the True Value should appear as "Yes"
-
How to link a column to another sheet so I can run a formula on duplicate values?
Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added or deleted. I considered a report, however that would only accomplish part of the job, as I want to filter the results. I…