-
Reference to other sheets not changing in countifs when saving folders as new
Hi. I have a smartsheet setup with multiple countifs to other sheets - all within the same workspace. When I save the workspace as new, the references are not changing to the newly created sheets even though I have selected 'Newly created sheets' in the any reports, dashboards, sheet hyperlinks and cell links will refer…
-
Link to excel file on our network
Is there a way to link to an external excel file without having to upload?
-
AIA G703 - Form Template
I’ve created a modified version of the AIA G703 form in Smartsheet for use in monthly tracking of my financing of a land development project. Each time a new funding request is made, a new sheet is submitted which includes a colum for “work previously completed” which needs to sum several columns from the previous funding…
-
l
l
-
Sub-task card lane driven my main card
I am using card view as a materials log and I have a question regarding the 'grouping' of cards. The problem: We have a pallet containing 4 boxes. The pallet is assigned to a lane in the sheet. I have created a sub-task card for each box on the pallet. When I move the pallet card the sub-task cards remain in the lane. The…
-
Countifs with OR across multiple columns
Hello all, I'm a fairly new (2 weeks) smartsheet user and I'm trying to write a formula that will count several columns based on specfic criteria. I want to count the number of Open projects (status) that are associated with engineering by either person/dept assigned column 1 or 2, and are of a safety concern (category)…
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Formula to copy a value to cell which is defined by day of month
Hello! My goal is to create a sheet where I want to store the values which are updated every day during sync with Jira. And I want to copy a value to a cell that is corresponds to current day of week. The result should be something like on the screenshot. So I need some kind of formula: value from Jira copied every day to…
-
Connect Action log (dates) with a project sheet dates
Hello; I am currently working with two sheets, one is the project plan and the second one with an action log corresponding to one of the phases of the plan. I have an issue when I am trying to connect log date & due date of each of the actions of the action log, with the finish date of some of the activities from the…
-
Count if formula and task progress
Hi, I've been trying every way possible to set this up so hoping someone can assist-- I would like to create a dashboard with a pie chart that shows how many tasks with a due date for the past 30 days from a sheet are done or incomplete. This seems simple enough, but Smartsheet keeps telling me I can only use numeric…
