-
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…
-
Are attachments completely deleted when a sheet is deleted?
Hi All, We are reviewing our destruction of confidential information process/policies. Wondering what happens to sheet attachments when a sheet is deleted? Are attached files / URL links completely destroyed and untraceable once the file is deleted from the deleted folder? Appreciate that any user downloads/reproductions…
-
Sheet not getting updated properly even if linked properly
hello my friends, I have a Master summary sheet that get updated via control center every time a new project is created. This master summary takes data from multiple sheets. For some reason, the data is not formatted properly, or it is empty or it is written Lorem Ipsum even if the data is rightly linked to the sheet…
-
Structures used to organize work
Hello, I'm interested in hearing ideas about any of the following: how you successfully use multiple sheets to organize phases of work across a project or program. For instance, has anyone had success tracking all phase 1-2 (for example: discovery and requirements gathering) tasks in one sheet and then, all phase 3 (build…
