-
R,Y,G and G - Part 2
Hey @Paul Newcome / @Andrée Starå , Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request. . In a nutshell, at the parent level, I'd like the "current health" (R, Y, G, Gray) to be the color of the highest risk child (or gray if there is…
-
Find Parent that is not blank or row with no children
How do I find whether a cell is a parent and not blank? I have tried =IF(AND(NOT(ISBLANK(Description@row)), COUNT(CHILDREN(Description@row)) > 0), 1, 0) which gives me the parent and not blank, but it does not give me rows that do not have any children. I need rows that are parents and not blank + rows that do not have…
-
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…