-
3 condition formula- Help
Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable" What I have so far: =COUNTIFS({KIM- Project Plan- TEST Range 3}, "LEG", {KIM- Project Plan- TEST Range 1}, >TODAY(), {KIM-…
-
Can Formulas Reference Reports?
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person. When I go to do that and the formula asks me to reference a sheet, I am only…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Workaround for all attachments sending in Update Requests...
Does anyone have a workaround for not wanting to show all the attachments for a row when an Update Request is sent with the option to attach a file? I am using Smartsheet to track RFPs and the information for each one is collected into one row on a Master Sheet using a form. This information will sometimes involve multiple…
-
Specifying a day to use with predecessors
Hi folks - Anyone know if it's possible to specify a day for an activity to happen in a sequence, when using predecessors in project plans? We have an IT review process that only happens on Mondays, and I'd like to set the predecessors for that task up to be the first Monday after the previous step is complete. Everything…
-
Creating a chart from non numeric values
I have created a form for users to fill out based on their experiences with a certain process. They will be asked questions such as "were instructions clear" and they can answer Very Clear, Somewhat Clear, Unclear. I was trying to create a pie chart from this sheet that shows how many users selected Very Clear vs. Somewhat…
-
Sales pipeline evolution metrics and dashboarding
I own a Smartsheet that captures all of the sales opportunities one per row and each marked with a pre-defined specific stage of the opportunity (investigation, qualification, archive, execution, etc). These will naturally evolve thru the sales funnel and individual smartsheet contributors will update the stage shortly…
-
Best Practices for managing 60+ projects in Smartsheet
Hello, I am a fairly new user of Smartsheet and have recently started at a construction company as a project manager where we design manufacture and erect large steel buildings for rural and industrial use. (From farm sheds through to aircraft hangers and fabrication workshops.) We have up to 70 projects active at any one…
-
If date is less than, greater than, or blank formula.
I am creating a formula that will display Completed, Upcoming, or Prerecorded based on the dates in Column 2021 Session Dates. When I use the formula below, any row with no date comes back as Completed even though I have added the IF ISBLANK formula to output Prerecorded. I don't get an error in the field, just not getting…
-
A formula pulling Time from a System-Generated column does not stay consistent. Please help!
I am using a formula to pull the time from a system-generated column using Created (Date). The formula is =RIGHT(Created@row, 8). A majority of the time is accurately pulls that correct information but other times it is off by two hours. For example, the screenshot is showing it accurately. But it will randomly switch to…
