-
Create a new row in Database2 when new text item is added to Database1
In my main project log (Database1), I have a "Customer" column with a drop-down list of all existing customer names; it is NOT restricted to drop-down values only so you are able to type in new customer names as well. I am using Database2 to assign each customer name a row to collect/sum specific data for all projects for…
-
Match or VLookup?
I cannot figure out how to cross reference two excel documents for changes made from one day to the next. Long story short, our EDI process is not working at this time. Until it is up & running, our csr is required to manually review each page for changes from the previous day. It is so time consuming but until EDI is up &…
-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
Alerts & Actions not working
I have set up several alerts, some are working, some are not. is there any reason why one alert would work and another not? can i attach my smartsheet for you to look at?
-
Skype Log in issue
When I try to sign in to Skype for Business, there will be a pop up for the sign in, but it quickly goes away and tries to do it all over again. I am using Google Chrome, and there are a few more people in our office having similar issues
-
Forcing a text field if a checkbox is checked (inside a form)?
I don't think this is possible yet but I'll at least ask. I have a change request form generated, if the reason for creating the form is due to a non-conformance i want to REQUIRE the requester to add a NCR# inside the form functionality not on the spreadsheet. Basically it would work as follows. Is this request due to an…
-
Link to excel file on our network
Is there a way to link to an external excel file without having to upload?
-
Update VIA API not showing updates
Hello There Super Noob to Smartsheet APIs. I am updating smartsheet, with Powershell, a Test Sheet sending simple sample data. It shows that I have added multiple row, in the test sheet, but it isn't showing the data even if I refresh the sheet. I have no Idea whats going on.
-
Sub-task card lane driven my main card
I am using card view as a materials log and I have a question regarding the 'grouping' of cards. The problem: We have a pallet containing 4 boxes. The pallet is assigned to a lane in the sheet. I have created a sub-task card for each box on the pallet. When I move the pallet card the sub-task cards remain in the lane. The…
-
IFERROR and ISERROR do not work properly!
No matter if I use IFERROR or ISERROR formula Smartsheet always returns #BLOCKED Some how the back end ignores the IF/ISERROR formals and is returning #BLOCKED =IF(ISERROR([Project name]1293), " - ", "Green") result is not - but #BLOCKED =IFERROR([Project name]1293, " - ") result is not - but #BLOCKED
