-
Is there a way or alternative way in referencing a formula from the Report?
Hi, I have a huge data in my sheet which is automatically fetching data from a google sheet. And to summarize my data to which I need, I am planning to use a Report but when I am computing for a COUNTIF, I have realized that the we can't reference a formula from the Report yet. Is there a new feature to convert Report into…
-
formulas not copying down
I run into issues with my sheets where the formulas do not copy down when new rows are entered. I understand that the new row cannot be blank and have clarified that to the users, but this is going to be a recurring maintenance issue. I have a fairly simple build where I am tracking billable time for a team. We are…
-
Automated Workflows and Charting Are Very Powerful
My Smartsheet application is going on six years old now and was in need of a rewrite after years of incremental improvements that used newly available capabilities in Smartsheet and as the needs of my company changed. My application basically takes project timekeeping data from an internally developed app via the…
-
Employee Reviews - Averaging scores for different criterea
Been playing around with a few index/match formulas but getting a bit complicated..🤯 To explain: Need to add numeric values to each dropdown to give scores to each critera Then search for each Reviewer that reviewed each employee and add all scores for each critera Finally, average the score =AVG(CHILDREN()) Went ahead and…
-
Red Yellow Green Gray
Hi Experts :), I need help with my formula. Principles I am trying to achieve are: if Min Variance column is blank AND the Minister Due Date is past today by less than 2 days, OR the Min Variance@row is Less than 2, then flag Yellow. If the Min Variance column is blank, AND the Minister Due Date is past today by more than…
-
AverageIF
I am trying to get the average number of days to fill a position, the formula I am using is pulling data from my worksheet for the Position type, date range, and days to fill. With my formula below I am getting an Incorrect Argument. I think it has to do with the bolded portion of the formula. =AVERAGEIF({Time to Fill -…
-
Workaround for resource leveling or displaying resource constraints w/o resources enabled
Working in small company, so we dont' have ability to purchase 10000 or have every resource assigned projects be SS users...is there any sort of workaround that could present similar picture?
-
Keeping Reference Sheet Formula
Hello, In Smartsheet, I have a metrics file that has formulas to consolidate numbers (sumifs) by referencing a raw data file. The first version of the raw data file was imported from an Excel file, and it has data in thousands of rows. Every 2 weeks, the Excel raw data file will be generated by our system and I will get an…
-
Ability to automatically update end date on a row, after row is created based on create date
We are currently using a Form to submit requests for changes and would like to use logic to update the end date of a row after the form is submitted and based on the create date plus X number of days OR after a status is updated, if the end date is blank update the row based on X number of days. Is this type of function or…
-
Need a way to fix row id, so they do not move
Hi, Little background, I am using below formula to get the row id in RowID column =COUNTIFS($Name$1:Name@row, OR(@cell = "", @cell <> "")) Now whenever I sort my sheet on the basis of date, the row ids also changes because the absolute reference changes. I am fine with sorting but I want the Row ID to always start with 1…