-
Unable to edit formulas
Any one have issues with suddenly not being able to edit formulas? I am admin and owner of the sheet one other admin has access to sheet and no locks have been placed on the cells.
-
Is there a way to show a particular image in a dashboard depending on which option is selected?
Hi Everyone, I am creating a dashboard that will show which locations are open so the senior managers can quickly check in the morning. It is simple enough and will show on the Dashboard that the location is open or closed through a Metric. I want it to look a bit better so have included a picture of the locations as in…
-
Workaround for =HYPERLINK
Each row has a unique ID and I use this to generate two different hyperlinks in excel with this =HYPERLINK(CONCAT("http://www.XXXXX/",A3),"URL") Is there a workaround in Smartsheets to do similar?
-
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…
-
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…