-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…
-
Can we have chart in sheet like we do in excel
Hi There, Can we have chart in sheet like we do in excel I dont want dashboard I want the chart % to be in sheet column Thanks
-
Dropdown List in Single Cell in Smartsheet
Is there an option to make one cell in Smartsheet have a dropdown list?
-
Report Summary - New function isn't working
According to this https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder I should be able to summarize my report based on ANY field. I am trying to summarize how many tasks an individual person has been assigned to. The help document says that a contact field should be…
-
Using IF with greater than or equal to a number
I want the "Complete" column to show "yes" if the total reviews is greater than or equal to 3. I cannot figure out what I did wrong with the formula above. Thanks!
-
Ignore blanks while detecting matching text across multiple columns
Hello! I am trying to write a formula for detecting ANY matches between "Affiliation" and "Affiliation 1," "Affiliation 2," or "Affiliation 3". If any of them match "Affiliation", then "conflict" is true. If false, it should say "none". However, if "Affiliation" is blank and matches another blank, it also outputs…
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
Record a Date automation keeps updating to today's date.
I am using the "Record a Date" function to identify an Approval Date when the status of a request changes to "Approved." The automation does record the date once the status is changed. However, once the date is recorded, the automation continually updates the date to the current date. For example: If a request was approved…
-
Date use with COUNTIFS formula (Non-Specific Date)
I have set up a summary grid pulling information from another Support calls grid so I can keep track of logged calls completed by members of my team. I am currently using the formula below to pull that information for one of the team and it works fine. =COUNTIFS({Support calls Range 1}, "Complete", {Support calls Range 2},…
-
Form not showing up in list of sheets- but link works
Hello, I created a form for people to confirm they've read my info. Sent the link to the form. The link works for me, I've received confirmation that I've used the form. But when I log into my account, the form does not show up on the list of sheets, nor is it located in the "manage forms" section. How is it possible that…