-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
Can you vary working days as part of duration?
I have some tasks that can only occur M-F in a schedule, and I have some other tasks that occur throughout a weekend. I don't know how to give the days different designations. I know there is a way on MS Project, but I have not figured it out for Smartsheet.
-
Help with IF Statement with multiple SUMIFS
Hello, I am trying to sum up a range of data from two spreadsheets based on the same criteria. Here is my formula which is throwing an #UNPARSABLE error and I cannot understand why =IF(SUMIFS({Advertising Total Cost}, {Hardi}, =$Region$1, {Year}, =2021, {Month}, =[OCT-21]$1, {contract}, =CATEGORY@row) AND(SUMIFS({misc…
-
Help with (date) helper column anomaly
I am using a helper column to provide a date from 'Date created' column that auto adds date and time. The helper column date can then be used to calculate days btw it and today. I am using the formula =DATEONLY([Date created]@row) but the helper column shows the day before as in the screenshot below. I have experienced the…
-
If / isBlank statement
I am having a total brain cramp and cannot figure out the formula I need for this. two columns: Task Status Closed Date There is automation setup that when someone marks a row as Task Status = Completed, it should capture the date and put it in the Closed Date column. Well, that automation works 90% of the time, but we…
-
Why has my metric sheet stopped working?
The following table counts data from a sheet using COUNTIFS functions. EG countif it a question and = the row or countif its an alternative proposal and the row. However the its stooped counting. For example there are 5 'Role specific' questions in the sheet but the table below shows 3? And there is one Alt. prp but none…
-
Nested if helper column to set project size
Hi all, I am trying to create a nested if statement to set the project size to Small, Medium, or Large based on the estimated number of hours that project will take. This is what I have: =IF([Est Effort (Total Hrs)]@row = "30-120 (2-3 weeks)", "Small", IF([Est Effort (Total Hrs)@row = "120-320 (1-3 months)", "Medium",…
-
Conditional Formatting Referencing Other Sheets
Hello, I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names…
-
Requestor carry over: Form pointing to another form
I have set up an initial intake form which gives the choice to go to another form: one form or the other depends what they want, e.g. request a report or request access to a file. With either form, the filled out request goes to the same smartsheet that captures the request regardless which form they use under the column…
-
What function do I use to capture the highest risk rating
I have a riks register that includes a column for a rating eg critical, high, medium or low. I want to surface to another sheet/report/dashboard a summary of all risks in the risk register as 'Risk health'. My thinking is that this woudl be the highest rating of al in the register. What function would I use to determine…