-
Merging to contact Columns
Hi, I am looking for a workaround to merge to contact columns into a third column (where the merged contacts from other two columns should also be contacts). The new third column type was changed to Column, still not able to figure out the formula. The need for the merged column is to use in dynamic view (restrict view by…
-
Automations from a Template are now Broken in existing sheets
Hi Community! I'm having a problem with automations. I added new automations to my template that was originally used to create some existing projects. Once I added the automations to the template, existing projects immediately inherited the new automations and now they're ALL broken. See screenshots. When I tried to start…
-
Will Blank Values Map Over in Datamesh?
I have data in a source sheet that changes occasionally. If a field gets mapped over, and then is later deleted in the source sheet, will a blank value also transfer and override that cell in the target sheet? In ex. below, Field 3 gets mapped over and then is later deleted. Will the target sheet look like option 1 or…
-
Power automate integration with Smartsheet
Can someone please help me how to integrate power automate with Smartsheet. I'm using sandbox environment in Power automate to test the scenario, but was not able to figure out how to connect them. Use case: To use Smartsheet column values to automatically update one-drive excel dropdown.
-
Workflow Automation Run History/Log
Is there a way we can see a log of when workflow automations have run, and if there is a recipient for it, then to see which recipient(s) have received it & when?
-
Trying to Join Multiple Rows to one cell
I am trying to combine all of the data into one cell for a row, but also any additional rows that share the same PO #. I then plan on taking this information and moving it to another sheet in order to set up Shipping and Delivery notices. I am still pretty new to smartsheet and I have tried googling and watching videos on…
-
Export Timeline View
Timeline is such a good feature, with a straightforward entry, as well as color edit. What isn't available is being able to export it on to PowerPoint or Excel. When is that coming?
-
Checkmark's
Hello, so this might be a strange one but doing this to run automation. i have the Bolo column set to check others sheets for serial numbers. i created a remove bolo column to search the Bolo Column and to find any Checkmarks. then wanting it to set a checkmark in the remove bolo column that has a checkmark in the BOLO.…
-
%Completion Rollup of projects doesn't make sense for parents of parents
Hello, I'm realizing for a project, the % of completion of the Parent of a Parent task, doesn't consider the size of the Childs of the Parent task. For example, in this case I have two Parent tasks, both of them are 10 days of work, one is 10 task of one day each, and the other is one task of 10 days. Once any of them is…
-
Index/Match Help
Since Excel created XLOOKUP, I have lost my ability to properly do index/Match, I am getting an #INVALID COLUMN VALUE error. First here is my formula: =INDEX({Deliverable Tracker Approved Archive_Delivery Liaison download complete}, MATCH(Help@row, {Deliverable Tracker Approved Archive_Help2}, 0)) This screenshot is from…
