It showed 2 parenthesis were missing. I attempted to add them to the end, however I got an error that the syntax was incorrect. Screenshot of the error shown at the bottom. I am having issues with thi…
Hi all, I am having some issues running a seemingly simple formula to get the days between 2 dates in my sheet (screenshots below). I first tried to just subtract the two date columns and received an …
Hello! I am trying to manipulate a formula in my sheet summary to return a percentage complete based on the value selected in the dropdown menu I created. The formula I've tried (and a few variations …
I'm designing a project plan template and would like to use an INDEX/MATCH formula to populate a "Business Unit" column based on the staff member assigned to a particular task. Doing this would then a…
I have a fairly simple ask and I originally built the formula myself, but since the output was an error I ran it through Smartsheet formula generator and our internal company AI. Both gave the same fo…
I need to count the total number of cells within a column if they have either Red, Yellow, or Green symbol. We also have the grey symbol, but that should not be counted. I am using this as a way to in…
I'm trying to add a column that indicates if a line item is urgent or not. Urgent meaning the due date is past or within the next 5 days. The formula I am using is =(cell with due date)<=TODAY(5) I ke…
Summary: I have a data sheet with a primary column listing different equipment items. Going across, there are a number of columns, 15 of which have drop downs with options N, N/A, Y, and Open Item... …
I'm really struggling with countifs in my Sheet Summary. I added a helper column to sparse the month. I want to count if the created date is February, and if two columns containing IDs are not blank. …
Hello, I have a formula set to count how many projects are flagged within a specific function if they are listed as in progress, but the count is off and I can't figure out why it's not counting all i…