-
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…
-
Daily metric widget problem in dashboard
Hi, I have a problem with a metric widget I would like it to show me the row that is for current day. Is there a way of doing it or do I have to make a report.
-
Toggle Hyperlinks
I have a need for a cell to hyperlink to different URL's based on whether or not the logged in SmartSheet user's email address (i.e., SmartSheet ID) is internal (i.e., works for our company - e.g., tim@ourcompany.com) or external (i.e., one of our customers - e.g., bill@clientcompany.com). Is there a way to do that via a…
-
Autofill field using the IF function
Hi I have two columns. One is called "Hierarchy" and the other is called "Description" I'd like to have "Description" automatically filled with this text/forumula "=PARENT()" if the value in the Hierarchy column is "2" Can this be done using the IF function or through another method? Thanks