-
With no developer experience, is is possible to populate a form with information from a row?
I have a form for teams to fill out the requirements for a specific product. I would like them to be able to pull up the original information in the same Form format to submit any changes or additions. This would then essentially create a new row, with an updated version number for us to track.
-
Constantly being kicked out of Smartsheet account and (saved work lost)!
Over the past few weeks, I am frequently being kicked out of Smartsheet while in the middle of doing work. Saved (either auto save or manually saved) work are lost when I get back in. What is the fix for this? I asked other users that share our business account but no one has reported this to me yet. The last time I was…
-
VLOOKUP Based on Name and Date
Hello, I am having some trouble with a query allowing me to look up values based on the name of an individual AND within a certain date range. The data table is weekly updated with new values, and has multiple fields, including name, date and comments. I need to pull a comments field, based on name and date. Thank you in…
-
There was an issue connecting
Hi , I am using smartsheet-csharp.sdk version 2.101.0.0. When I consume my web application on my laptop and on a UAT, everything are working fine but I am having problem in production. The utility returning "There was an issue connecting" exception. This is my code: var _smartsheet = new…
-
Free collaborators cannot see content
I wonder if anyone else experience this issue and if Smartsheet changed access terms for Free collaborators. I recently created simple smartsheet and shared with 2 people, but they only see empty sheet. no content. any ideas ? how do i log issue with Smartsheet support ? Thanks
-
Calculated % Complete
We use three fields to indicate effort: Planned Effort Actual Effort Remaining Effort I created a column called '% Comp" with the following formula: =IF(ISBLANK([Remaining Effort (Hours)]@row), 0, IF([Remaining Effort (Hours)]@row = 0, 1, (([Planned Effort (Hours)]@row) - [Remaining Effort (Hours)]@row) / [Planned Effort…
-
Contact List
Hi Another newbie question! I have updated the details for a contact in Accounts / My Smartsheet Contacts, eg I change the details for 'Nigel' to 'Nigel M' . Likewise, I also deleted a Contact. However, when I go back to my Project, the Assigned To column still shows 'Nigel' and if I go into the Contact List in the…
-
Access blocked from China - workarounds?
Hi, not sure if others are aware, but Smartsheet is not accessible from China right now. We have a major issue with one of our global customer's Chinese employees unable to update project information in Smartsheet. Hoping the community can help us out with some solutions. We are finding out if they can use a VPN to access…
-
Automated process to start after comparing?
Hi. Please help how could I get such a scenario: Trigger: a flag in a cell If the data in another exact cell in this row is equal to the data in another table's cell (that contains the preliminary data, autocopied to current table), then auto-scenario B. If the data is not equal then auto-crenario A (re approval process).…
-
Frequent "Aw Snap" errors in one of our sheets when trying to save
Hey community - we are constantly getting Aw Snap errors when we are trying to update and save one of our sheets. It does have a few conditional formats, but not many and same with automations. It is quite a large sheet with 5563 rows, but way under the maximum of 25,000. It does however have quite a few hierarchy's and is…
