About RobinSilk

I am trying to limit the options in a dropdown list so that a user cannot select "option A" for both "slot 1" and "slot 2". In the attached image, the equivalent would be blocking the user from assigning "testtest" or "matt 622 upload" in the third slot for the parent "CUMMINGS, JAMIN".   Note: every parent should be able to select every option once, but never more than once. What is the easiest way to do this? Is there a certain way I need to setup my lists?   Thank you in advance for any help. ... View more

Hello,   I have a numeric line item (picture attached) with cells filling in as 1 if they fulfill a condition, 0 if not. The total number of 1s in this example is 1514; I need to reference this total in another line item in a separate module.   This separate module is not dimensioned off of any lists. How can I do this? From what I understand, SUM and SELECT require common list dimensions, is that true or am I mistaken?   Thanks,   Robin ... View more

In my model, I have the Current Fiscal Year set as "FY20:  1 Jan 2020 - 31 Dec 2020." As we move into future years this will be updated. I need to write a formula that pulls the last date of the current fiscal year; for this year it would be 12/31/2020 and when we update the Current Fiscal Year in 2021 it will be 12/31/2021. The goal is to compare the last date (12/31/2020) or last period (Dec 20) to a line item value in a different module that does not have a time dimension.   I have a system time module set up (pictures attached) wherein I should be able to identify the last period, in this case, Dec 20. I do this by comparing the period month number to 12; if it equals 12 I know it is the last month in the year and the last period. Is there a better way to do this without hardcoding 12?   Once I have identified the last period in the system time module, I need to be able to compare/use this value to values in other modules that do not have a time dimension. How can I do that?   I can provide more details if necessary. Thank you in advance for any help provided.       ... View more

When looking at the page for the rank formula, there is a callout that says " Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I am wondering how blanks could be excluded from a rank formula where I need to sequentially rank records based on when they are created in a list. ... View more

Within Q1, January is the first month (1), February the second (2), March the (3rd). Then Q2 starts, and April is the first (1), May is the second (2), and so on.    Is there a good way to set something like this up?   I ask because I want to build an IF AND statement, in which IF a value exists within a cell AND that cell is #2 within that quarter, a cell will be populated. ... View more

  We are asked to import Emloyees.csv into SYS08 Employee Details and I am unable to get the names in the list to match on the names in the employees list that I already have in. I checked and I have the data type as "Text" listed within the SYS08 module, and the .csv has the data in that column listed as "General". I also tried changing that to "Text"; neither work. I can do it manually but it will take a long time.   Is there something I'm missing or should consider?       ... View more