-
Comparing Three Columns
I have three columns that I want to compare. I thought an If(and( statement would do it but I keep getting #incorrect argument or #unparsable errors. Each column is a dollar amount and I basically want if Column 1 < Column 2 and Column 3 return a value. Below is the expression I've been trying. =IF(AND([EXTENDED COST…
-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
Formula for if checkbox is ticked
Hi I need to add a formula on the end of this formula please. I need to add if 2026 investment list is checked too. This is the formula =COUNTIFS({Exec Sponsor}, FIND(Metric@row , @cell ) > 0, {Intake Status}, FIND("Project Approved", @cell ) > 0)
-
Reminder Automation
Hello everyone, I need help in this!!! I’m trying to set up an automation where a reminder is sent to the contact list 1–2 hours after a row is added to the sheet. Is this possible in Smartsheet? If so, could someone please help me with the setup? Thanks
-
How to calculate the number of submittals completed each day.
I am currently working on a construction project where I am tracking Request for Information (RFI) for our subcontractors. I can get up to 30 RFIs a day. My question is what is the best way to track how many I process daily? Is there a Countif formula or a DataMesh process that works best?
-
Auto Create Schedule Based on Needs
Does anyone have a template that can create a schedule based on needs? For example: we enter the number of contacts calling us per hour per day and how long the calls take, how long it takes us to answer, the service level we want, list of full time and part time techs with their normal hours they work and a two week…
-
Extraer la Hora de 2 o mas celdas
Buenas tardes, como podria extraer la hora de registro de 2 ó mas celdas? o como podria registrar la Hora en una celda?
-
Date/Time field should be Date&Time field
Timestamps are only included on Created Date and Modified Date but it is useful to have a specific timestamp that will not update every time the row/sheet is modified. This would be a huge help especially when using the Duration field or other formulas. Either update the Date/Time field to include the time like Created…
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
AVG Collect Divide by Zero error
Hello, I am stumped again. I am looking to average data from another sheet and am getting a #Divide by Zero error, even though I believe the formula is written to ignore zeros and blanks in the data. What am I missing? =AVG(COLLECT({Indirect Project Summary -Avg Leadtime}, {Indirect Project Summary - Executive Sponsor},…