-
Dropdown (Multi Select) Sheet Column In A Form
I have a Smartsheet column configured as a Dropdown (Multi Select) column type and do not have the checkbox ticked for "restrict to dropdown values only". While entering data in the column within the sheet itself I am able to enter values in addition to those provided in the field's value list. However, when I attempt to…
-
Report based on 3 sheets with the same primary column
Hi everyone, i want to make a report based with 3 sheets (Financial informations, planning informations, others informations) which have a common reference in their primary column. I want to have all the informations automatically on the same line. Please, can someone help me? Thanks.
-
Can anyone assist me with VLOOKUP formulas?
I have an employee register sheet and another sheet. I would like to use the VLOOKUP function to populate some of my employee information in my other sheet when I select my employees' names. The VLOOKUP formula gives #NO MATCH errors or sometimes gives the same employees information in all the cells. Has anyone else…
-
Error 1012: 'Required object attribute(s) are missing from your request: values.'
I'm having difficulties with the AddRows method in Smartsheet's C# SDK. I have been getting the error code 1012 with the message 'Required object attribute(s) are missing from your request: values." I have seen others post similar issues but with 'cell.value' as the missing attribute. In my case, what is 'values' supposed…
-
Multi-automation approval request
I have a form that when submitted should trigger an approval workflow. The approval email is sent out when triggered, but after the approval has been made the submitter from the form does not receive an email. See attached workflow. The Sponsor Email column is where the email address lies to be contacted once approval or…
-
Importing Excel Spreadsheets into Smartsheet
I am trying to automate a function that we desperately need. We have a spreadsheet that is generated every morning and every night. I want to import it into a Smartsheet that I will use for a Dashboard. My problem is that every time I import the spreadsheet it creates a new Smartsheet and I lose my Summary fields. I need…
-
Formula Not Working. Turning Sizes into Numbers
Hello, I am trying to write a simple formula where I translate a size value into a number. For example in my column called "Size": I want to create a formula that turns the following size into corresponding numbers in another column. XS = 1, S = 2, M = 3, L = 5 My formula is as follows, but doesn't work? =IF([Size]1 =…
-
Disabling Field Logic?
Hello Community, I am sure this is an easy task but for the life of me l can't make it happen. I setup some field logic to make the user enter a date only after the condition was met, since this is a new process and user is still catching up with entering the data, we decided to disabled this logic so they can just fill…
-
Counting number of new rows using Created (Date) and resetting each week
Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday. I want to: "Look in the Created (Date) column of Sheet 1 and count if the date [that this row was added] is…
-
Pushing data from Smartsheet to 10000ft
Hello, i am trying to set up a project request form which requires authorisation and once this is recieved it pushes fields through to 10000ft as a new project. I can see how to send info through to Slack and MS Teams, but not 10000ft. Can anybody help? Thanks