-
Running Budget
Hi, I am working on a Daily Expenditure Report and on the top line where normally we would add everything below it for a grand total... but in this case, I need to know what the ending balance is, rather than a total for all expenditures. I tried this, but it references a specific line below. =[ENDING BUDGET]15 If I add…
-
How to include comments in an automation e-mail body?
Hi there, I've got an automation setup that includes comments in the e-mail that is generated from SS. In the email response, all the fields minus attachments and comments show up. When you click the "Open Update Form" button, you can expand the comments. Is there a way to include them in the e-mail either innately or…
-
Matching Multiple Criteria to Populate a Specific Result
Hello! I need to match data in (2) columns that will populate a result in a 3rd column. Columns I need to match data in: Type Column and PS Qty Helper Column If Type Column is "SM" and PS Qty Helper Column is "Dual", I need "PS Qty Dual + SM" to Populate "1", so that we can then count all of the lines that have "1" to know…
-
Amalgamate 2x Formulas
Dear Forum i have 2 formulas, which both work in independant columns. Id like to amalgamate with a further IF command: 1. =IF([Document Full Name]@row = "", "", IF(Supplier@row = "SPL: Civils", INDEX({KO1A - BIM CAD QA - PLG Powerlines Task ID}, MATCH([Document Full Name]@row, {KO1A - BIM CAD QA - PLG Powerlines Full…
-
MULTIPLE CHECKBOX TO DETERMINE PROGRESS OF PROJECT AND AUTO UPDATING STATUS
Good day, I have multiple checkboxes which determines the current status of the project. I want a column in the front to give me the details of the most recent checkbox in the row. The checkboxes follow a specific order as the project progresses. So the first one must be complete before the second one can be selected. I…
-
Date Format
Hi There ; In smartsheet is there any field to setup a cell format to date and time together (like : 26.11.2020 10:24) thanks
-
Countif (Archiv:Archiv; 0)
Hi, my sheet summary currently counts 49 hotels when I set the filter "Archiv=0". It should be 39. I guess the reason are the blank rows under the filled rows. But I cannot delete them. Every time I delete the rows and save the entry, then setting the filter, the blank rows appear again. Any idea what makes the magic ;-)
-
Need Formula Help
Hi Dear Community ; I am new about smartsheet so i would like to get your kind supports i need a formula like that ; i have a sheet as below with column names , in my scenerio i am getting datas with forms from last users , for example when the last user choosed the "Status" Column as "completed" , i want that the date of…
-
Joining multiple multi-select entries from different columns into a single cell WITHOUT DUPLICATES
Hello, as above, I am trying to join the data of all cells within the same row into a single cell without duplicates. In the screenshot below I am working with the following formula: =JOIN(DISTINCT([Column3]2:[Column6]2), CHAR(10)) How can I modify this so that instead of the result being "A B B C" the duplicate entries…
-
Formula works but is counting blank cells
I got my formula to work =COUNTIFS(Offender:Offender, FIND(Offender@row, @cell) > 0) but now I have no idea how to make it stop counting the empty cells. Can someone help?