We are using a sheet to track candidates for a position. We need X number of candidates to Y positions. We're using a formatting trick to show when the target number has been exceeded but it would be nice to be able to limit the number. Users would still need to edit the existing candidates.
Hello, I am trying to access data from another sheet using a reference to another column within the row using a sum formula usually in excel I would create a =indirect() reference, how could I replicate something like that within smartsheet.
Hi Everyone, This question was asked before but I have not found an answer. So asking again to see if there is any new development which I have missed. I have set up an automation to copy rows from each project sheet to a master sheet (based on some trigger). The row for the first project was copied arbitrarily in the…
I simply want to have Smartsheet autocomplete my data as I enter it in a cell as Excel does. Is there a way to turn this on?
I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tried it just text) off all the dates each work type has work. I am then on a separate…
Hi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this case I would only like to count the unique TR ID's for the month of August, 2020…
Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my case specifically, =((8 * 5 * 7) - SUM(CHILDREN())) ) If a work order has multiple…
Hello, I have a sheet in which I am tracking distributor complaints. I need to make a few different graphs. One of which is supposed to be a line/tally graph of how many complaints have been made by each distributor. We have a list of almost 40 different distributors which we have in a drop-down select form, for the ease…
Which function do I use to count the number of times certain letters eg PRJ and TRN appear in a range if in another column the project is open (not closed).
Let's assume for a second that I have a file that is titled "Project Info". I also have a folder called "Projects". Every file in the project folder has the same columns though the project names are different. In Project Info, each filled row will have a unique key that references one of the files in Projects. What I am…