-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
HYPERLINK Function
Hi @Genevieve P., @Paul Newcome, Cc: @Art Schneiderheinze, @AJW, @Andrée Starå Are we any closer to getting a HYPERLINK() function in Smartsheet? Something with a familiar syntax such as... = HYPERLINK( Link_URL, [Display_Label] ) I know this has been discussed on many old threads, but I have been able to calculate a…
-
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?
-
RACI Template
Is there a RACI template that Smartsheets already has or does anyone have any suggestions?
-
Sending a Notification not Working
I am still new to Smartsheet and I am trying to add automation to send a notification to a email account but it is not working. I have no restrictions on the project . Can someone help.
-
Stock control
Hi I am tryingbuild a new Stock Control system using barcode reader on my mobile feeding into the sheets. The issue I have is adding the items up on one sheet and adding to items to another sheet to work out stock levels. I am tried using the barcode or ref no as the Lookup.
-
IF Calculations
I have three columns I'm dealing with, SALARY IRA(check mark) IRA amount if the ira checkmark is checked, take SALARY *0.035 in the ira amount column