-
Formula Help - Countif in Multi-select column
Hello - Two formula questions: 1. I am trying to input a countif formula into a Summary field that will count how many times the name of a specific team appears in a column that uses a multi-select dropdown. This column also has some fields that are blank. Below is what I have tried and am receiving an 'Unparseable' error.…
-
Taking a dashboard "snapshot" as a pdf and attaching to a given row
While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to a sheet ("sheetX" for later reference). What I want to do is try and capture a part (or…
-
% Complete Parent Row
I just started using Smartsheet and I was wondering if someone could help me. I want to basically calculate the % complete, as the dependency setting does for you automatically. However since I entered a formula in my % complete column (if status is "done" then automatically give 100%, if status is "in progress" then…
-
Counting current months in a date column
Hello, I am trying to get a count of due dates in the current month, here is the formula I am using and it always returns zero. the formula is in a text/number column and the data is in a date column. =COUNTIF([Due Date]3:[Due Date]204, MONTH(TODAY())) I,m a beginner and could really use the help. not getting errors, just…
-
Checkbox populated another column with date
Hello I have a checkbox column that I want when checked to copy the shipped date form one column (Shipped Date) to another column (Customer requested date). Is this possible with a formula?
-
CountIF where cell contains specific word
Hi I've read a few posts and dicussions but still can't seem to find an answer that I can use. I'm collecting data and have some basic dashboards setup which display the number specific words are recorded. As an example: Clinical Clinical Lead Clinical Specialist Lead Operational Lead I need to be able to count how many…
-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Formula to sort by date based on another criteria
Hello I am looking for a formula that will tell me how many times a certain criteria comes up per month. We have a quote log that has different stages and we need to know how many of each type of quote stage exist per each month. In the attached screenshot I need to know how many quotes were "Develop" in the quote stage…
-
Prevent Formula Overriding
Hi there! I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox. The issue I'm having is that the formula erases if someone…
-
Reference Another Sheet Ranges Shifting
I have a metrics sheet built out referencing a master sheet. The master sheet is a running tracker and each month we add new rows to it. Any time we do this, it shifts my reference ranges on my metrics sheet. We've tried adding new rows to the very bottom of the master sheet as well as inserting the new rows between…