-
IF(OR(Find Statement
I am trying to build a formula that searches in a column for a certain word using FIND( and I would like to add OR to that. I am using this formula and it is working fine: =LEFT([Address]@row, FIND("TZ", [Address]@row) - 1) I would like to add FIND("GZ" so that it returns either after finding "TZ" or "GZ" Thank you!
-
Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting) Person A: Sheet X=# | Sheet Y =# Person B: Sheet X=# | Sheet Y =# I have a report grouped by person that has both sheets feeding into it but…
-
Intake data-> Project Sheet...Why so difficult????????????????????????
All I want to do is take what's in a row in the intake sheet and have it populate into a column in the project sheet. I feel like I'm making this too difficult, but after much review of previous helpful answers in this community, I still have issues I can't solve. Hoping you all can help. Issue 1 Index match gives me the…
-
Text to Columns: Getting rid of letters in between numbers
Hello, I have this date in this form 2022-08-21T02:04:38Z and I am trying to get rid of the letters 'T' and 'Z' in the middle of the date. Thanks.
-
IF OR Statement For % of completion
I am trying to write a formula that returns the status of the project based on a column labeled as "% Completion", if the % of completion is 100% then status should say complete. if "% of completion" is 10% then status should be in progress. This is what I have come up with but it's giving me "INCORRECT ARGUMENT"…
-
Easiest solution I have for (time)-(time)=duration
I always look here for solutions to my ideas before I spend too much time on them. I was not able to find a simple solution for doing calculations with time. Honestly, after my initial search, I ended up exporting to excel to do the math, then importing back in. Long story short, here is a single formula to subtract start…
-
How do we apply COUNTIFs with multiple conditions?
I Have 5 Columns namely Phase 1, Phase 2, Phase 3, Phase 4, Phase 5 I need a count of each row item (Less than 100%) with a condition that if a task is less than 100% in multiple columns like phase 3 and phase 4, it should be only counted in the first column (Phase 3 in this example)
-
Link an individual task?
I've tried searching for this and haven't found info - I apologize if it's out there! Is it possible to send a link to an individual task? Sometimes, that's helpful. Since I group all relevant info into individual tasks on the card (e.g., attachments, links, and any conversation), it's sometimes really great to send a link…
-
Quickly Navigate Back to Smartsheet from WorkApps
Hi Community, Did you get tired of having to open a separate browser tab when you wanted to return to Smartsheet from a WorkApp? We sure did, well not anymore! Our latest update allows users to seamlessly navigate from WorkApps back to their work in Smartsheet with just one click by selecting the Smartsheet icon on the…
-
Actionable meeting summaries
Hi everyone. I got a question and would like to learn from your experience: Any examples of how you use Smartsheets to write actionable meeting summaries? Here's what I have in mind My goals: Creating a "Meeting Summary Area" for each project, that will include all meeting summaries. Summaries must be concise and…
