-
Index(collect) argument
Good morning, This should be a simple formula to create but I am not properly completing my argument. I have a sheet that has three columns, Most recent (checkbox), date, & summary. From another sheet I want to receive data that is in the summary column if the checkbox in the most recent is checked. The logic on the target…
-
Downloading the attachments associated with a row in a report
When I run a report that has an attachment on each row - is there a way to download the attachment without having to download each attachment separately and then match them to the row information? The report has 100 rows and matching the attachments will be a nightmare. Thanks
-
Use Formula to Check Checkbox as a Column Formula
I found this formula in the community that works perfectly to check the box if there is any text in certain cells. =IF(OR(ISTEXT([Column1]@row), ISTEXT([Column2]@row), ISTEXT([Column3]@row), ISTEXT([Column4]@row)), 1, 0) I'm getting a column formula syntax error when I try to apply it to the whole column: "The column…
-
Hierarchy issues
Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I have been tasked with taking over admin/owner duties now. I understand the basics and…
-
Summing up time in the format HOURS:MINS:SECS
Hi All, I have a list of tasks with estimated time of duration in the format Hours : Mins : Secs I am looking to sum up the total of all tasks however I do not think Smartsheet likes to sum up values that have a semi colon breaking up the number. Is there a way around adding these up? Thanks!
-
Workflows and Conditions
Hello, I have a data collection sheet that stores a variety of sites data. I will do my best to explain the setup, as well as desired outcome. This sheet contains two forms, (1) a data collection form used for new sites [requires 3 Point of Contact (POC) emails, site name, and various other fields that will not be…
-
Sorting an Indexed Date
I am pulling a date into my dashboard using an index and Match formula. When I go to sort the data, it sorts the date from left to right so 1/2/23 is before 1/3/22. I thought I might need helper columns to break the date out into month, day and year columns and sort on year then month then day. I get invalid data error…
-
Health Ball Color Based on progress
Hello I have =IF(OR([COS 2022 ACT - YTD]@row > 0.05 + [COS 2021 Baseline]@row, "Green", IF([COS 2022 ACT - YTD]@row > 0.1 + [COS 2021 Baseline]@row, "Yellow", IF([COS 2022 ACT - YTD]@row > 0.15 + [COS 2021 Baseline]@row, "Red")))) COS 2021 Baseline COS 2022 Target COS 2022 ACT - YTD Can you please help me with this: over…
-
Creating At-Risk Formula for Level of Priorities
Hello, I'm not sure where to begin for this so looking for some guidance. In our Legal Management Sheet we prioritize requests by the following: Urgent - Less than 1-3 days turnaround time to execute the contract. The vendor contract is vital and needed immediately to complete an initiative/operation of the business (excl.…
-
IF OR with an IS Date?
Looking for some support on this