-
Can a milestone task be closed based on completion of an approval task?
In each of my parent group of tasks I have an approval task, followed by a milestone task. Both are important for reporting. Example: Task1: Manager approves ABC Webpage for publishing Task2: Milestone: ABC Webpage ready for publishing - Predecessor for Task2 is Task1. Problem: When Task1 is marked Complete, I want Task2…
-
Need another pair of eyes - Know there is an easier way
I have 2 sheets (soon to be 3) where I am pulling metrics from 25+ different sheets to get monthly data. It is working, but every month I have to manually edits every row (over 300) to add the next month of data. So I would love some ideas on how to make this easier and less manual. Here is an example of my sheet and…
-
Expression using the "Created Date" field
I am trying to have a column default to a specific dropdown option in a grid/sheet if the "created date" = Today. Is there a way to use this?
-
Identifying Duplicate Values through Conditional Formatting
Smartsheet Community Members - I'm using Smartsheet (Forms) to manage system access requests. Users provide their Username and to which System(s) they need access. I'm trying to employ conditional formatting so I can easily identify which requests are duplicative based on whether a request already exists for the same…
-
Using COUNTIFS with OR function spread across multiple ranges
Hello, I am trying to build a COUNTIF function that will count all cells which meet criteria 1 and either criteria 2 or 3, which are found in different ranges. Example: In Sheet1, I have the following columns: shape, color1, and color2. In Sheet 2, I would like to create a function which counts all observations in Sheet1…
-
Workflow Best Practice in Smartsheet on below scenario
Dear Smart Team, I hope all are doing well. I am having below scenario of workflow with 7 to 8 level of approval. 1) Scenario 1, Type in (A, B, C) This workflow is requires 1 verification and 7 Approval (1,2,3,4,5,6,7) 2) Scenario 2. Type in (D, E, F) This workflow is requires 1 verification and 6 Approval (1,3,4,5,6,7)…
-
Previous, Current, and Next Weeks with New Year
Hi All, I'm wondering if there is a more efficient way to identify the previous week, current week, and future weeks when the year changes to the new year. I am using the following formula: =IF(AND(YEAR([Change Start Date]@row) = YEAR(TODAY(30)), WEEKNUMBER([Change Start Date]@row) - WEEKNUMBER(TODAY()) = -49), "Tree…
-
Monthly Sequence
Hi - uploaded an excel sheet to Smartsheet that is not compatible with a formula. The formula in excel was: =EDATE([Column9]14,1) which calculated the next month (1/1/2024, 2/1/2024, etc.) what is the smartsheet version of this? I can't drag the dates because it is a row and not column of dates.
-
Trouble with Auto Number column type. Shows up different in cell.
Hello, I am trying to use the auto number system and am having a little trouble. You can see in the first image that I have programed it and the preview is pictured as well. First cell should populate as C001. From the second image, you can see how it populates in the cell. It is stating with the number C011 instead. Can…
-
conditional totals per column
Hi all Hoping I can find some help on this formula, Trying to figure out how to create sum totals of PO value column at the top of each of the first 3 columns (FERG JOB #, FVLV#, JOB SHOP #) if information is present in those cells. contingent on any of the items in the drop down list from PO/SDR down being selected. Any…