-
Automatic formula
Hello everyone, In some fields in my sheets I have formulas. Is there a way to automatically report these formulas when I add new rows? Thanks
-
Onboarding Template Questions - HR
Hello! Has anyone used the Onboarding Template for New Hires in Smart Sheet. We are trying to figure out the easiest way to duplicate the sheet for new hires and have them all roll in to one dashboard. We noticed another user commented that using the Project Template worked for him for onboarding new hires. How are you…
-
Formula to Copy cells if no match?
I'm looking for a way (probably some sort of Index/Match formula?) to check for a customer name on 2 lists. If the name shows up on the second list, but not the first, add it also to the first list. Here is our specific set up: The first list is a workflow tracker where most people will start. The first step in the…
-
How can I create a material inventory and order form in the same sheet
Hello, I am very new to Smartsheets and am trying to streamline inventory and how our partners order materials from us. Currently, partners email members of our team and someone fulfils and tracks the order manually in an excel sheet. I want to create a sheet that tracks inventory with an order form that subtracts from the…
-
Trouble reaching a human
Hey all, I made a mistake in registering for some training at SmartSheet University. It has been like 2 weeks of trying to contact a human to resolve my issue. I have opened tickets, left messages, sent emails, .... and not 1 person has reached out to me. Do any of you have any suggestions trying to contact someone? I…
-
Data Shuttle to .pdf
I would love to see this data shuttle feature to include the option of saving as a .PDF. I currently have to export individual sheets as .PDF then drag to another sheet to attach the .pdf to a row. Adding a data shuttle feature that would automate the process of attaching a pdf of one sheet to the row of another would be…
-
Calculating Dynamicly Average
Hi there , İ need a formula for a dynamic calculation , i added a sample as below , lets explain what i need ; At below table yellow field area contains August 2023 datas, white field area contains September 2023 datas , imagine that every each month , i amm adding new lines to this table also , So i have a dynamic tabe…
-
Formula for Adding Sums based on Matching
Hello. I created an example for what I am needing help with. I need a formula that sums a column if the value at the row matches a field in another sheet with my current sheet. In my example, sheet 2 is where the formula will live - I need the grand transaction total for each clothing amount so in this example, the formula…
-
Trying to flag an item within a date range.
I am using the Asset Management template set and need to have the dashboard update when an item is due within 7 days of the assigned due date. I tried the below formula: =COUNTIF({Sheet - Asset Tracker Range 2}, TODAY() + 7) Asset Tracker Range 2 is the assigned due date. This is giving me everything due exactly 7 days…
-
Sumifs with dynamic criteria from multi-select dropdown
I have Sheet 1, having rows where a record can be assigned values from a Multi-Select Dropdown with Requirement IDs (REQ1, REQ2, REQ5). I have a separate, Sheet 2 with Requirements. Each Requirement has an ID and a Weight. ID, Weight REQ 1, 5 REQ2, 5 ... REQ5, 3 I want to assign REQ1, REQ2, REQ5 to a record in Sheet 1 and…
