-
MS Power Automate Get Last Row of Data
The desired flow is: Smartsheet form is completed which includes three key pieces of info: Name, Email, Waiver This creates a new row in a Smartsheet A Power Automate flow is triggered where it checks specifically the Waiver (which is a dropdown either needed or not needed). If needed, the flow continues. I built an…
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…
-
Countif with contains
I want to count the number of times the word Booth is contained within a row for each of my vendors on my sheet. There are other words in the row such as cancel or no show. I have tried =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @cell) and =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @row) and…
-
Locked column changing to date column type
Looking for some help, I have a sheet where I have locked a column to a contact list type. When I log back in to Smartsheet at a later time, the column type is still locked, however it defaults to a date type. This is happening on another column as well which is not locked due to requesting updates from those assigned in…
-
Am I doing it wrong? Salesforce connector, Mesh, control center, Data shuttle ugh and now RM
:) Replacing a JIRA system that was not really used well with Smart sheet and Sales force in a united front to try and perform work flow, report out, and track time, then export for billing back to Salesforce. High level, we have a pre sales sheet that captures input from Salesforce on win, loss, and or type of project.…
-
Restore Historical Versioning of SmartSheet
Last week I encountered an issue that caused several of my columns to get misaligned & information was no longer in the correct column. I did not realize that this had happened until the sheet had already saved. After chatting with multiple CS reps, I then realized there is not an easy way to restore the sheet to a…
-
Intake Sheet column entries lost
Hi, Ive changed a column from Project Sponsor to Business Sponsor and it seems to have deleted the previous entries in the columns. I can rectify by looking in activity log but is there a quicker way to restore the previous data in this column
-
Sheet Statistics
Something that quickly shows # of rows # of columns # of cells # of cross references # of unique formulas I'm sure there are other metrics that would be nice to see quickly Close to breaking warning or notification to sheet owner Could be part of Work Insights but all together, like a table, and update immediately.
-
How do I add conditions to an existing filter?
Hi, I have an existing filter comprised of 6 predicates which all have to be true. I want to edit this filter to add a predicate (to make 7), but I only seem to be able to remove a predicate, not add one. Can anyone help please? Thanks, GAM
-
Index/Match - Primary Sheet to Individual Sheet
Hi Community, I am looking to track training at the individual employee level as well as for my company overall to provide statistics. Currently I have two sheets. One is the primary tracker, and the second is an individual employee sheet (template). The primary tracker has approximately 107 columns, each column represents…