-
Dropdown Form Entry
I want users to enter data via form and one of the fields is a dropdown list and I do not have the restrict list to values selected. I want people to be able to submit new entries via the form but it will not accept any that are not already pre-defined in the dropdown list. This seems like a defect to me. People can add…
-
Function Help - Sheet References
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. I need help with a specific formula that would…
-
Smartsheet Policy for your Company?
Has anyone written a Policy & Procedure for your company for rules around using Smartsheet? I'm working on one now and don't want to reinvent the wheel (If anyone is willing to share) - and would take any suggestions of anything you recommend I include in our policy. Off the top of my head, I'm thinking we need to cover: *…
-
Manage Azure AD users in Smartsheet
Hi, Currently we have a Business Plan Suite, is there a way to manage our Azure AD users in Smartsheet? For example, We have our personal info filled in in Azure AD, how can I import this into Smartsheet? Thanks in advance.
-
Dynamic View: Give access for requestors via their email address
Hi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while handing in the request and then they have to login in to status view with this email…
-
How Nested IF can I get?
I have a desire to change a Status column based on whether (or not) certain separate (other) columns are populated with a date. Is this supposed to work? All of the Nested IF examples I have seen tend to look at just a single column to evaluate against, and I'm wondering if I'm going to be able to make this work, and using…
-
Automated Workflow - Invalid Date Error
I have set up an automated workflow to trigger when status changes to complete if date field is greater than 12/31/18. I am able to choose the date but it changes to "Invalid date" when i save the workflow. I thought maybe since the date field i was using is an automatic number field, it didn't recognize the field as a…
-
Creating a bug burndown dashboard in Smartsheet
Hello, We are currently using the SmartSheet + JIRA connector which allows us to export JIRA stories to SSheet and have bi-directional editing capabilities of both sources of data. This works great and allows team members (like our QA team) who do not have JIRA accounts to update their SSheet and the changes are…
-
Linked Cell Format Issue
Hello everyone, I have tried looking for this topic, however, I can't seem to find anything. I have a source sheet with dollar amounts and the cells include a number such as $100,000.00. When I link the cell to a new sheet, the number shows up as 100000 Any idea how to fix this? Thank you. Sincerely, Diego
-
FILTER
Hi, Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report. I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all…
