-
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…
-
CountIF using AND
Hi all, Can anyone tell me what might be wrong with this function below? =COUNTIF((AND([Field CSA]:[Field CSA],"Name"),([Status]:[Status],"TEMP"))) I need to count the occurrences where the Field CSA column has the word Name and where the status column has the word TEMP. When each value appears in their respective columns…