-
Formulas not showing in new rows
Hi, Not sure if this is a new issue but formulas in sheets aren't showing in new rows if there is a parent row below it. The first attachment shows how the sheet is setup and a number of columns have formulas in them. If I add a row between Test 3 and the Applications Confirmed parent row, it won't pull the formulas down…
-
Formula Autofill Fails with Sheet Summary References
I have information from my project information sheet (Project ID, Project Manager, Project Name...) linked into the sheet summary of my schedule, risk, issue, and other project management sheets. I then link this information into the sheet via the formula =[Sheet Summary Field Name]#. Otherwise associating a particular…
-
AVERAGEIF
Hallo, unfortunately the result shows "#unparseable". Where is my fault? ;-( =AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; >1; <=50000)
-
TRYING TO RETURN THE DAY OF THE WEEK.
trying to get the Day of the week (ie. Mon, Tue, Wed) to return based on a date column. Tried this, but getting and unparseable error - what am I missing? =IF(WEEKDAY[Bid Date] = 1, "SUN", IF(WEEKDAY[Bid Date] = 2, "MON", IF(WEEKDAY[Bid Date] = 3, "TUES", IF(WEEKDAY[Bid Date] = 4, "WED", IF(WEEKDAY[Bid Date] = 5, "THU",…
-
Creating a series of narrowed down drop down menus...
Is there anyway to setup a rule whereby you select from a dropdown menu in one column, then the column next to it gives you a specific dropdown based on your selection and then based on that, the following columns auto-populate. For example: Columns 1. Manufacturer 2. Model 3. Device Reference 4. Device Type 5. Price (1.…
-
Updqate request or email from Smartsheet => get an absence notification from outlook into Smartsheet
Hi experts ;-) yesterday I enthusiastically presented again Smartsheet and one of my colleagues objected: "sending emails in Outlook is much better because you immediately can see if the receiver is present or absent." Is there a way to get this information in Smartsheet, too (at least receive the absent notification sent…
-
How to make existing attachment and comment "Read Only"
In the created workflow after the task is complete the row is blocked. But attachments and comments are able to be corrected and deleteed. How to prevent this for blocked row?
-
Compare the hours allocated to the hours actually worked, through timesheets
Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which projects. This time worked on projects would be compared to the time allocated to the…
-
SUMIFS Fees Assigned to Project, but EXCLUDE Fee for Current Line Item
I have different project fees attributed to the same project. I'd like to show the running cost in the "Project Spend to Date" column, while excluding the "Fee" from the current line item. This is what I'd like to create. Date 1/25/20 - Project A - Fee $5000 - Project spend to date = $3000 (Currently showing $8000 with…
-
Help on creating formula for % complete, weighted on children
The sheet has each job recorded as a parent row with sub tasks as the children. Each task is allocated hours for the job to be completed (taken from a pool for the entire job). % complete column for the child rows is entered manually depending on how complete the job is. Yellow highlight on screenshot shows total allowed…
