-
Help with formula Sum IF i think ?
Hi I Am after some help getting a column of numerals to add only if certain criteria in a drop box are met say if Column A was made up all of the number 2 and Column B i had drop box criteria of "Complete" If i marked Column B "complete" my value would be 2 if i mark 4 Rows in Column B "Complete" my total would be 8 Any…
-
Constraints in predecessors in SmartSheet ?
Hi, I want to create the gantt with schedue as below: Task A Subtask A1 Oct 15 to Oct 19 Subtask A2 Oct 15 to Oct 19 Subtask A3 Oct 22 to Oct 26 Subtask A4 Oct 29 to Nov 2 Predecessors of A3 = Subtask A1 and Subtask A2 Predecessors of A4 = Subtask A1 and Subtask A2 Subtask A3 and Subtask A4 are assigned to the same…
-
Credentialing Tracking Template
Hello, I am looking to set up a credentialing tracking template. I would like to track the credentialing process including but not limited to documents submitted/pending, approvals, etc. I'm curious, does anyone out there have any examples of such templates? Any ideas are much appreciated. Thank you!
-
Sumifs and Children
I am trying to sum the values of child row if three conditions in adjacent columns are met, from another sheet and post it on my main sheet. I reference a parent row and need to sum the children values if they meet the three conditions . Specifically, I use a cell value from the main sheet to find the referenced parent row…
-
Smarsheet data share over mobile no instead of email
Hi everyone At present I am sharing data with others over their email addresses. Is there any method of sharing data over their mobile no? Say user has a what's app installed on their mobile and status update request or report can be shared on mobile?
-
Formula for RYG using % Complete and Finish Date
I am trying to populate my Status field, using RYG formatting (based off the % Complete and Finish Date). I am trying to use an AND/OR and it is not working for me. I can get half way there, but not completely. My Status Definitions: Gray - Not Started Yellow - In Progress Green - Completed Red - At Risk I would like to…
-
If a checkbox
Hello again. I need some help please with automation/formula on a project management sheet we use. (Action 1) I have a checkbox column called "SNAGS" When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager. (Action 2) Like wise, I have…
-
What the best way to manage 8,000 Projects in Smartsheet
I am new to Smartsheet and not sure how or if the program can help...I have project where I am rolling out a new program to 8,000+ locations and looking for way to leverage Smartsheet to manage. I know there is a 5K row so not sure how to proceed. Most threads talk about pulling rows out once complete but my project is a…
-
Formula Tips are Obscuring the Actual Formula
Hello, Could anyone provide a trick to move the formula tip dialogue box? I am getting an Unparseable error message, but I cannot see the formula to check the syntax (see attached screen shot). Are other people facing this problem? Is it browser specific? I am working around this by copying and pasting parts of my formula…
-
Need Help - Can't Wrap my Head Around SS Logic
I'm trying to build a metrics table that can be used to generate a graph on a dashboard. I am a consultant and would like to track client hours from a master sheet that logs all clients, dates of services, and total hours. Let's say I wanted to track the hours of utilization from a particular client from YTD, Last Month,…
