-
Need a condition to override other conditions in a formula
Hello, I need to show a percentage rate in one column based on a time of year in a different column, however, if there is a certain word in a third column, I need it to override the other conditions. Right now, the formula is: =IF([Program Term]@row = "Summer", 0.325, IF([Program Term]@row = "Academic Year", 0.499)) I need…
-
COUNTIFS question, stumped
I'm trying to count how many "Yes" is in the column (options are Yes and No). The column name is "Do you plan to stay overnight May 1st?" I feel like this is probably simple but I've been stuck on it for 2 weeks. HALP
-
Unable to convert a vlookup formula into values
I have multiple columns with column formulas built that do a lookup into another Smartsheet. Want to convert the lookup values into values in the workbook that I built the formulas in, and then delete the workbook that is currently being referenced to find lookup. I cannot figure out how to do it. I do not see an option to…
-
PMO Template Set: Suggestions for challenges with how Schedule Health is calculated?
I am struggling with how Schedule Health is calculated in the Project Plan that comes with the PMO template set – it seems misleading and not an accurate reflection of health because: After setting a Baseline, the Schedule Health is still calculated using Target End Date (which is likely a different date than what is in my…
-
Add multiple amounts together for multiple selections
I am trying to create a formula that can look at a column with multiple choices, put a number value for each option chosen and add them together for a total. So if they choose option A, amount is 400, option B, another 400, option C, 500, etc. the column would add those amounts together to get 1300. Here is what I have so…
-
Get dollar amounts in K to show up as full numbers?
Hi there, I have a sheet where dollar amounts come from Excel into the sheet as $x K. I would like to have these format as $x,000. Is there a way I can do this using a formula? Interestingly, when I use import functionality, the numbers convert automatically. But in this use case, users will be copying and pasting single…
-
Formula for %
Im looking for a formula to return the percentage that our projects are over/under.
-
Remove an update request with a formula or workflow?
I have a sheet that will automatically request an update if certain parameters are met. But sometimes the fields get marked directly through the sheet instead of through the update request form. Is there a way to automatically remove the request update if the parameters are met through the sheet? For example if there is an…
-
Conditional Cell Linking between a sheet and a form
Hi, I have created a form in Smartsheets which has different logic, depending on the user's response specific questions appear, and user inputs specific information. This gets created in a sheet in a different set of columns. Reading this table which is directly being populated from the form can be difficult as one has to…
-
CountIF and OR Formula
Hello, I'm trying to construct a COUNTIFS formula which is currently: =COUNTIFS({Arrival Date}, {Arrival Date} <= DATE(2023, 7, 31), {Arrival Date}, >=DATE(2023, 7, 1), {Status}, "Provisional") This works and returns a value but I also want it to include {Status} of "Confirmed" as well as "Provisional". I've tried:…