-
Pivot table only has 2 decimal places
I'm creating a pivot table using the Pivot App from a sheet (also tried from report with the same data, and neither resolves the issue), where the values are percentages that go out to 2 decimal places. (Ex. 95.25%) The pivot table is converting the values (whether I do sum or average) to a number and only two decimal…
-
Automation Question
Hi. Is it possible to use the Trigger "When rows are added or changed" with a Run workflow other than "When Triggered"? I would like to send one notification daily (or weekly) to include all the updates. Thank you!
-
Variables with formulas
I'm fairly certain this isn't possible but it would make my life easier so I figured I'd ask. I would like to be able to create formulas with variables as placeholders so I can apply different calculations to two variables N & X Essentially, I'd like to have a column where I define the formulas such as: 2X + N 0X + 6N +3…
-
Excel import on Existing smartsheet
Hi Team, is there a way to update existing smartsheet with newly excel import. our use case is, import the excel sheet 1st which will create a unique smartsheet. after that we need User to make requied udpates on excel and import the updated excel sheet in smartsheet where it should import the data in existing sheet. for…
-
Required Slack Integration Reauthentication
Hi Community, We migrated our Smartsheet integration with Slack on February 5, 2025. Why we migrated: We’re always working to get more features to our users, this migration makes the connection between Smartsheet and Slack more stable so we can build new features for you in the future. What this means for you: Starting on…
-
Any way to update formula criteria with drag-fill
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52) and have =COUNTIF([Week number]@Row, =1) which works but I am wondering how to then extend the formula to automatically…
-
Automation to record values from one smartsheet onto a new row on another smartsheet once a week?
Hello, I imagine the answer(s) to this question already exist but I haven't had luck finding them, please point me in the right direction, here's my situation: I have a Smartsheet ("sheet 1") that my team records numbers on during the week every week. "Sheet 1" has 100 rows, and there's one column ("column x") in "sheet 1"…
-
Dynamic View Search Functionality
Our team often needs to search by program, client or product numbers. I can't find a way to do this in Dynamic View other than Ctrl+F, which only returns results that are currently visible on the screen/window. Any suggestions?
-
Count String Occurrence in a Cell
Hi There, I have below two columns in my sheet. Column [Status (Delivered)] has concatenated values (WIP and Delivered). In [Delivered Count] column, I need to show how many times 'Delivered' string occurred. Please see below example.
-
INDEX MATCH
Hi all, I have two table. In the first table I have band names in the first column like ACDC and a contact column (where the formular should be used). The second table will be filled via form. First column is the submitter second is free text. If the free text is "ACD" it should match with "ACDC" and the email from…
