-
Formula don't work in reports
Hello, I have formulas working properly in the sheets, but not in the report. For example, when a task is "Complete" in a sheet, the done checkbox is ticked and the dot gets grey; when I do the same in the report, only the status is updated. Similarly, in the sheets a formula makes the dot yellow 15 days before the end…
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Countifs with age ranges
Hi. I'm trying to write formula where the age range is 10>= and <=19 yrs old. Here's my formula: =IFERROR(COUNTIFS({OHCA Form - Agency}, $Agency@row, {OHCA Form - Review Complete}, "Medical Review Complete", {2021 OHCA Form - Etiology}, <>"Trauma", {OHCA Form - Incident Date}, ISDATE(@cell), {OHCA Form - Incident Date},…
-
Adding values in a column
I'm trying to sum the values in this column, but the formulas I have tried aren't working. The values are linked in from another sheet. This is one formula I've tried: =SUM(At Risk Count1:At Risk Count89) but it's unparseable. Can anyone help? Thanks.
-
I am wondering how I would add an If to a formula to add an additional approval layer when needed.
I had a simple 4 person approval process that looked to see if 4 people selected "Approved" it will make a cell as "All Approved" and send an alert. Current Formula: =IF(COUNTIF([Jim Approval-RD]@row:[Angela Approval-RD]@row, "Approved") = 4, "All Approved", IF(CONTAINS("Declined", [Jim Approval-RD]@row:[Angela…
-
Creating a Date range
I am trying to create a date range and keep getting an error. I would appreciate assistance. Thank you =COUNTIFS([Business Unit]:[Business Unit], "CAI Business", Status:Status, "In Progress", (AND [Start Date]:[Start Date] >4 / 1 / 21, [Start Date]:[Start Date]<06/30/21))
-
Supplier management
Hello. I would like to monitor a group of suppliers to whom I send a questionnaire. Is it possible to automate a mailing every 6 months, for example ? Is it possible to send 2 attached documents via Smartsheet ? How can I do this ? Is it possible to manage the return of this questionnaire in my database ? How can I manage…
-
Removing all of the irrelevant footer information added by Smartsheet to Automation emails
We are using automation to external workers to update smartsheet. We have a number of issues that have been aired before. The smartsheet owners name appearing in the email address. Confuses the worker when the sheet owner does not interact with worker. Only option is to use a licence and set it up as a general name so that…
-
Index A Pivot Table
Does anyone have experience using Index on a pivot table? Or perhaps there is a better way. We use a pivot table to summarize various stages of the sales process (not contacted, needs contact, active priority, hot needs call, warm needs call, etc). I need to pull the summary numbers from that pivot table each week into a…
-
List Based on Date
Hello, I have a sheet with multiple columns. 2 of those columns are "Name" & "Date". If the date is older than 14 days, I would like to get a list from the Names as well as the Date. I don't need any of the other data from the other columns. Just a list with the names and dates of anything older than 14 days. Thanks
