-
SUMIFS PROBLEM
Hello, I want to create a formula to calculate the value in $. I want the exact same criteria as my COUNTIF. No matter what i try my formula with SUMIFS will not work. Thanks in advance for your help!
-
How can I restore formulas and cell links in a sheet?
I have sheet that relies heavily on formulas and cell links to stay updated in real time. Recently the sheet was toggled with and no longer contains any of the cell links or formulas (only hard coded numbers). I do not know what every cell was linked to or its' formula. I tried to request a snapshot using the activity log…
-
Data String Type Different in Budget vs Time & Hours Data for Advanced Reports in RM
Is this a bug or just a limitation? When I create an Advanced Report based on Budget data in RM, the Data String type in Smartsheet is automatically a Date format. However, when I create an Advanced Report based on Time & Hours data in RM, the Date String type is Smartsheet is in Text format. Is there a way to have them…
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…
-
Use index that make dynamic formuale in the row.
I am trying to replicate an Excel dynamic sum in Smartsheet. I have a row containing data for weeks 1 through 52. I want to sum the values starting from the current week (based on today's date) through week 52. In Excel, I used a dynamic range, but Smartsheet is giving me an error. How can I sum a specific horizontal range…
-
Track Monthly Submissions from Multiple Locations
Hello! I have been using Smartsheet for a few years but have really only used the basics. I have a form for our branch managers to submit their monthly safety checklists and wanted to see if there was a way to track / indicate which locations did not submit and for which months. On the form, there is a drop down for them…
-
WORKAROUND FOR AUTOMATION EMAIL TO RECEIVE SEPARATELY AND NOT BUNDLED IN ONE E
Hi anyone here have a work around or formula in my case i created a project where in Effectivity date reach it sends email notifications i also created a helper column for subject to have a unique fields and not bundled in one email but in this case if the same effectivity date different details it was placed in one email…
-
Formula - Counting and Blank Data
Hi. I need to know what is the best way to Count but exclude any cells that are blank. I am looking to count how many machines I have per my programs but I don't want to count the ones that have no date. I've read I should start with Is Blank but that didn't work. Thanks you in advance. Ali
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
INDEX help NO MATCH
I want to pull the dates into this data sheet from the Schematic prep column on the Master sheet. What's wrong with my forumla??