I'm trying to get the last non blank date value if the value that pulls is blank. We have a sheet that make a separate line for each part of a process, and has the dates for each start. The "Start Date" column should fill with the date that corresponds to the Index for that Run. In the below example, they have a start date…
I'm trying to get a row in the smartsheet calendar that shows the count of runs per month. Is that possible? Right now I have tasks grouped under a common name, and had to create two extra columns, Month of Start Date =DATE(YEAR([Start Date]@row), MONTH([Start Date]@row), 1) and Runs in same month =COUNTIFS([Project…
I'm trying to change the iframe code for my smartsheet dashboard embedded into sharepoint with a responsive height and width (100%). The code doesn't seem to be picking up the % sign, and instead is making it 100 px. It's supposed to fit in this entire square: Any ideas for my code? Thanks!
I'm trying to reference different columns based on a value in a helper column. Depending on the value in the helper column, the value should be pulled from a different column. I know I can do this with nested IF formulas, but is there a way to have the column name populated in a formula based on lookup formulas? I wanted…
I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from? My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should…
