-
Help with Calculation
Hey all, I have a form with multiple fields. I'm trying to figure out how I can create some type of count that would tell me, how many fields in that form were filled out vs. not filled out. In addition, I'd need to apply several filters to the data that is being counted. Is this even possible? 🤯😬 Thanks, Carlos
-
COUNT formula that will count one or both conditions.
There are 2 columns that lists the name in one of the columns or both. When the name pops up in one column, I want that to be counted as one. When it pops up in one of the columns, I also want that to be counted as one. Is there a formula for this?
-
Duplicate check in two columns using IF OR and COUNTIF
I need to check two cells to see if they already exist on the sheet so I'm using a duplicate check formula and OR, but it's not working properly. It works for the email address, but the Full Name does not work. =IF(OR(COUNTIF([Full Name]:[Full Name], [Full Name]@row) > 1, 1),COUNTIF([Email Address]:[Email Address], [Email…
-
I want to link the same cell repeatedly. Is there a formula that hyperlinks or cell links?
I'm hoping there is some kind of formula that would make things som much easier.
-
Can having Index link mess up the formulas?
I have formulas on my smartsheet that were working absolutely fine before, however have stopped working recently. And I can't figure out why, except we recently added index links to the smartsheet. Could that be a reason? Any suggestions or help would be appreciated. Thanks.
-
Form attachment not showing in the Smartsheet grid
I have a form built for incoming requests that includes an attachment field. When the form is submitted, the document does not show in the grid (or any other view) as an attachment. How can I update the form-to-sheet flow to ensure the form's attachment is added to the incoming row?
-
Only showing data applicable to the person logged in (WorkApps?)
Hi, I am new to using WorkApps. I am in the process of rolling out a global solution impacting ~1000 project managers. I want to keep them away from the main data sheet, limiting access. I think/ hope I can achieve a WorkApp solution just giving them the details they need to update on Project progress. Is there any way of…
-
A couple countif formulas
I have a couple formula questions: I want to count the number of employees hired from 1/1/21-until today (and have it update to be today in real time moving forward). So far I have =COUNTIFS({GB Users Source Sheet Range 1}, @cell = "Active", {GB Users Source Sheet Range 5}, "Full Time", {GB Users Source Sheet Range 4}, I…
-
Countif help where range column contains column formula and text
I'm trying to create a summary metric of my active projects using countif. My project status column contains the following column formula, which works fine. =IF([Current Stage]@row = "Stage 5", "Active", IF([Current Stage]@row = "Stage 4", "Active", IF([Current Stage]@row = "Stage 3", "Active", IF([Current Stage]@row =…
-
Need help creating a custom duration formula
Hi! I need help with a formula to automatically update the "duration" column each day as well as only count weekdays and not weekends. Is this possible? Here is some more information. There is a "date submitted" column. A "status" column with three options: Not started, In progress, and Complete. There is a "duration"…