-
Joining the Results of Boxes Checked on a Form Entry (2 Solutions)
Edit: I had used numbers as my column names which in turn populated my first row. Another user made a good point that the number 1 in the first row will not actually duplicate my column name, but will read as "true" since it is a checkbox column. The column names and formulas have been updated to account for this. . I…
-
IF Function
I've been trying to find a way to combine various checkboxes to designate different status', for example: If this checkbox is checked then this is the status However, if that checkbox is checked AND this checkbox is checked, then it's in a different status If these 3 checkboxes are checked, then it's in a different status
-
Trying to expand my knowledge of writing formulas
Im having a little bit of a hard time trying to make formulas longer and saving column space(s). For instance when I run into an issue of creating a formula in 1 cell i sometimes create a new column and put the formula I wanted to add in there. This takes up space which can be free'd up and when the sheet gets over 1000…
-
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…