Is it possible when more than one row having same value( duplicate row is submitted) an alert message goes to the user that row already exist something like this..?
Hi Tanveer,
Yes, it is. Didn't I help you with something similar the other day? Do you want it to work in another way?
https://community.smartsheet.com/discussion/duplication-form-creation
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
Looking for formula help to accomplish the example below:
Hello. I need help please. I am working on a Smarthsheet schedule where I need to define the calendar (ie exclude public holidays and our annual construction builders break) without enabling dependencies because that messed up my sheet previously. I have a separate sheet that has a list of non working days. My formula is a…
