Discussion List
Children Parent % not calculating
Hello, I'm trying to build a sheet that calculates a percentage off of a Status column, but the column is not returning a percentage and the =AVG(Children) section. This is my mess of a formula =IF(IsParent@row = 0, IF(OR([Rally Status]@row = "Submitted", [Rally Status]@row = "Acknowledged", [Rally Status]@row = "Not…
Automation Workflow Step Through Mode
Create a mode that allows administrator to step through an automation workflow. Feature should allow stepping through one step at a time and being able to go back to the sheet to see the result to that point. Also provide method to select a point in the work flow to stop the workflow at a specific point while in this mode.…
How to calculate the days in que from a form?
Do I need to add a column to record the date of each approval?
Countifs multi select column and year column with contains
Hello! I have a multi-select column from which I am able to get a summary formula to count correctly, but every attempt I've made to account for the year from a second column has returned errors of some kind. The Year column has a formula in it as well: =YEAR([Contract Fully Executed Date]@row) This is the formula that…
Allowing people to edit reports without having access to the main sheet
HI All, Is there any way that I can share reports with people and give them the ability to edit information through these reports without sharing the main sheet with them? I have sensitive date on the main sheet that i do not want them having visibility of but would like them to be able to update a number of key fields of…
Can I block someone from editing a specific column if they already updated another column?
Column 1 is the status. I want a 2nd person to verify the work from column 1 in column 2 and I want to block whoever edited column 1 from editing column 2
Smartsheet data used
Hi, we are getting to use more and more data smartsheet and i would like to know how much data I am using to control the data storage rate. Do you know how we can get this information. Best regards
Rows that were un-highlighted before copy row workflow coming up highlighted on destination?
We have several individual sheets in which rows are highlighted and cleared during business hours. After business hours, each sheet has an automation that copies the days entries to a master sheet. Why, if the rows are no longer highlighted on the source sheet at the time of workflow run, are they appearing highlighted on…
Update requests not sending emails
I have been sending update request out to have people do some updates but recently its not sending out the emails to people. I even sent one to myself. I get the notification in Smartsheet but no email. I check my permissions and email notifications and all are good. I also check the automation and its set to unrestricted.…
Help stacking COUNTIFS?
I have two fully operational COUNTIFS functions that calculate independently without issue. One counts how many absences occurred in a specific time range by referencing a date column on an attendance tracking sheet. The other counts how many absences occurred in a specific location by referencing a location column on the…