jwilson
jwilson
Reactions
Discussions
- I work in Regulatory Biotech and started using Smartsheet to summarize our Global Submissions data to the Global Health Authorities. Look forward to Smartsheet updating the functionality of charts!
- I'm trying to match the "Application" # (Table 1) to the "Application Name" (Table 2) and return the corresponding "Primary Product Family" (Table 2, Column 2) into "Program" (Table 1, Column 1) using…
- I'm using the VLOOKUP Formula to match the "Application" in table 1 to "Application Name" in table 2, then return the "Primary Product Family" from Table 2, Column 2 to "Program" in Table 1 where the …
- In the table below, I have 3 columns that are text/number fields: Final Document, Target Date, Actual Date. In the Target MM/YYYY and the Actual MM/YYYY, I have a formula to pull the MM/YYYY from the …
- How can I use the MONTH function if the cell is blank? It is returning #INVALID DATA TYPE. I'm pulling this information into 3 columns from the Actual Submission Date Column: "Month" - new column with…
- I am attempting to create a "Current Status" column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my "End Date" column is 90 days…
