-
Can I create a dropdown to lead to another page?
Hey guys, trying to create a dashboard where I could have different dropdowns and hoping that when someone clicks on the option, it could lead them to another page. Is this possible? If not, any ideas on how I could execute this. We are trying to create a one-stop-shop where our team can click on something and lead them to…
-
Can an attachment be referenced in an Alert messages like other columns?
I have an alert set up to notify management when a new status report (attachment) is added to a sheet. Each status report is attached to a single line in the report history sheet. I'm sending a simple message to non-Smartsheet users with some basic info from the sheet using {{column name}}, but to get the attachment…
-
Countif and formula
Hi I am trying to create a formula that counts how many times "Engineering" appears in a column when the column next to it that is either "Delayed, Set Back, At Risk for Delay" Here is what I tried: =COUNTIF([Critical Action Department]2:[Critical Action Department]51, CONTAINS("Engineering", @cell)AND([Task Status Based…
-
Get value from another sheet based on value from source sheet
I am trying to get the proper or most efficient syntax to take a Contact Name from a source sheet and match the value in a second sheet to then bring back a value from the matching row. I am attaching a screenshot. Looking for accurate syntax of current function or better function. Function being…
-
Using IFERROR with MATCH to get an Exact Match
I have a lookup sheet where I am trying to pull data based on date. Some of the data in the sheet will be weekly and some daily. So my "Lookup sheet" has daily dates in the Date column. What I'd like to do for the weekly data is say, if the date@row is not an EXACT match, return a 0 or a blank. My similar formula works…
-
Smartsheet cannot determine >= and <= between dates when column property is not Date
I have columns Start Month and Finish Month, formatted as 1-2021, 2-2021, etc. I am trying to automatically populate an equally divided cost across my month columns based on the duration between the Start Month and Finish Month. I have a helper row at the top of my sheet under each month column to reference in my formula,…
-
Countifs with date range
Hello everyone, I am attempting to create a formula that references another sheet with multiple IF components, and I am stumbling with the date range. I currently have: =COUNTIFS({OPUS Range 1}, "Western New England", {OPUS Range 4}, "Completed", AND(@cell >= {OPUS Range 3}DATE(2021, 01, 01), @cell <= DATE(2021, 01, 31)))…
-
Progress Bar Formula
Hello, I want to create a formula that changes the Progress bar to full when the Status column is changed to Complete. I don't want a formula for any of the other Status options. Thanks in advance.
-
Need Assistance with Reporting and Dashboard Widgets
Hello, I'm working on a project to create a request intake form which then goes through approval workflows. Based on the requests submitted I need to be able to do some basic reporting such as #of requests, #of requests by approval status, #of requests by function, breakdown by month to see month on month trend etc. Every…
-
Manpower Summation from Schedule
Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. My…
