-
Help with Status driven by date columns
Hello, I am trying to automate my status column that is driven by dates. Date columns: Deployment Start, Deployment End, Planning Start, Planning End Statuses: Planning (this is default) status; Execution, Complete I'd like the status to default with Planning if dates are blank or within the Planning Start & End, Execution…
-
How to use SUMIF and the criteria is a range of values
Hi Everyone! Can anyone help me with that. I'm trying to use sumif function for a range of values. for example: I want to sum a values in a column if they range between 50 and 60. How can I do that? I used: = SUMIF( mycolumn, AND(mycolumn >50 , mycolumn <=60)) but its not working. Thank you
-
COUNTIFS with Specific Dates
I'm working on a Pre-COVID and COVID list and could use some help. Can someone take a look? One example: We need to COUNT how many times TRB was used during the dates of January 1st, 2020 to March 13, 2020. =COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), ([EventDate, >DATE(2020, 1, 1):EventDate, <DATE(2020, 3, 13)])
-
Automation - Update Requests
Hi - I submitted this as a question a while back, and thought it resolved itself, but the problem is still persisting. I have an automated workflow setup whereby when someone submits a Form, they receive an Update Request. The Problem The Update Requests are being sent out, according to SS, but people are not receiving…
-
Link from cell in other sheets not being updated
Hi, I recently repeated run into a situation that a cell (destination cell) which has a link from another cell (source cell) on other sheets (source sheet) was not updated automatically. I had to open the source sheet for the destination cell to update. This is driving me CRAZY! Why is this? Help! Sean
-
I am pretty new to smartsheet, but have a question about parent rows
I am using Data Uploader to upload a csv master file into smartsheet. I am trying to see if there is a way that I can dynamically designate a column or combination of columns to be a parent row in either the upload or in the sheet itself. The data in gray is what the input file would look like and the orange section is…
-
COUNTIFS from multi-select drop down
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works great since it is automated once the @row are filled in by my Team: =COUNTIFS({Planning sheet Range 2}, PA@row, {Planning…
-
Auto fill form drop down list field in one particular scenario
Hi. I currently have a column that can be either Capex or Opex depending on the chosen item from drop down list on a form. I have been asked to amend this so if another drop down list value is "X" then column Opex/Capex is to be autofilled as "Opex" else user the value entered on the form.... Any pointers for this please?
-
Random numbers / Random form questions.
I'm looking for a way to generate questions via a form. Say we have 100 questions on a grid split into 10 sections. In an ideal world I'd like to pick 3 random questions from each section and then have that listed on a form. One way could be to have a random generator of sorts and have it randomly assign a number to each…
-
PowerAutomate Microsoft Form Submission Date to Smartsheet Date Column
Good Morning, Hoping someone might provide some expertise on a date conversion issue I'm having. I have a Microsoft PowerAutomate set up to bring Microsoft Form responses to Smartsheet and create a new row. I would then like to identify forms submitted which =Today() give it a 1, then that is used in other columns which…
