-
Reports pulling from formulas
I have reports calculating off multiple workflow sheets based on a column in the worksheet with formulas - the reports sometimes appear blank and when I go into the worksheet to see why, the formula column shows as blank and then reappears - almost like they only recalculate when looking at the sheet. the fomula is a…
-
Count tasks between today and xdays+today
I have several different project sheets that contain communication tasks. I create another sheet to create a count of tasks coming up in the next 7 days (I plan to create a report to pull up to a dashboard). I am having trouble creating a formula that will count the tasks between today and today +7 days. This is what I…
-
IF statement to search data in two columns for matching text
I am somewhat new to SmartSheets, and would like to know if there is a more concise way of doing what I'm trying to do. I am using sample names for the purposes of my question. I have one column of data [Data Column] that contains different city names, some blanks, and some text that is not city names. What I need to do…
-
Capture Row history using API?
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
-
Is there a way to link multiple sheets to a metric for a countif scenario?
I am trying to feed the health on multiple sheets into a dashboard using a metric sheet. I am having trouble adding the secondary location to be included in the formula. Does anyone know if this is possible? Thank you!
-
Creating a Formula to track inventory
Hi All, i am trying to track inventory and alert appropriate personnel of when they should order more parts according to lead time. For the most part everything is working well. However, when parts come into the building and are added to inventory my formula still deducts anything that was sent previously. i am assuming…
-
Auto-populating between two sheets
I am currently working on creating some sort of link or equation, that could allow me to create a "directory" sheet where the names in the primary column could be linked to another sheet so that all the names would automatically become options in a drop-down box for another sheet. Is this possible at all, or is this a…
-
Average of Boxes Checked in Column
Hello all! I have a column of check boxes in which I'm trying to find the average number of boxes checked in a range. I'm trying to use the COLLECT function, w/this formula: =AVG(COLLECT([Photography Needed]2:[Photography Needed]5, [Photography Needed]2:[Photography Needed]5, 1)) When I do so, I receive the error =DIVIDE…
-
How to show "most recent status"
Hi All, I have a "Client Health" column, where I'm using the five hearts symbols to rate the health of a client from 1 - 5. The "Client Health" will get updated every 30 days, based on the current status of the account. This happens in rows 19 - 23 only. In Row 1, of the "Client Health" column, I want to display the most…
-
Using COUNTIF on a Range with Cross-Sheet References
I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet. The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF formula works but this destroys the advantage of using a VLOOKUP formula in the first…