-
Can Bridge get data from Admin > Groups?
Is there a known or suggested method or Bridge workflow I may use to record data from Admin Center > Groups to a Smartsheet? I want a workflow to look up the groups in our plan's Admin Center and replace the rows of a sheet and column on a daily recurrence.
-
New Feature: A redesigned access requests experience is now available for Smartsheet users
Hi Community, We’re excited to announce that Smartsheet’s improved asset access request experience is now live! This update helps collaborators and admins alike save time and reduce frustration by making it easier to request and allocate access to assets For Collaborators: Submit access requests with context—saving time…
-
Dashboard / Portal Background Colors
There have been a number of requests in the past for the option to have additional colors available for dashboards, especially to allow dark backgrounds to be used which are currently very popular. Can you advise if these requests have moved forward with the development team at all, some of them are over 5 years old and…
-
Make dropdown with multi select split into multiple rows
I have a list of Board Meetings with a column for who attends. Each meeting is one row. The board member column is a dropdown that allows for multiple board members to be selected. I need to track their expenses individually. Is there a way to pull them into another sheet with each board member on their own line? With…
-
How can I use cross sheet reference to combine columns from the source sheet into destination?
I've been trying to use a cross-sheet reference to combine columns from my source sheet into one column on my destination sheet. However, I can not even pull information from one of my cross references. This is the code I've been using. =INDEX({Job Book Job Number}, @row) It keeps giving me #unparseable If I use that…
-
ConnectWise Integration
Has any one here done an integration with ConnectWise? We have a small company whose resources all work production support and project tickets. If I had a way to feed tickets from CW in so that I could display all open tasks for one person that would be great. Thanks, Jacque
-
Function to get last modified date for cell
Hi, I'm looking to add a column that records the last modified date of a given cell/column in a row. I know that you can record this using automated workflows but I would like to avoid this solution as I'd have to update many Smartsheets - is there any way to do this using a column formula?
-
Status with Predecessor
Hey All, Need help with a formula. What I have works, but I want to add another condition to it though I am not sure how. I do not want the status to show as ready unless the predecessor is complete. I'd like a copy/paste formula vs referencing to a specific row. Thoughts? Here is the current formula =IF(AND([%…
-
Index/Match - Children
How do you use the index/match formula for a child based on the name of the parent. In the screen shot below. The yellow highlighted area would have the formula looking up who child row is assigned to based on the job # (circled in red).
-
Introduction
Hi my name is Freda Tesseneer. I am very new to Smartsheet so I could sure use your help. I work for Wanzl North America in Newton, NC.
