-
Formula Not Working. Turning Sizes into Numbers
Hello, I am trying to write a simple formula where I translate a size value into a number. For example in my column called "Size": I want to create a formula that turns the following size into corresponding numbers in another column. XS = 1, S = 2, M = 3, L = 5 My formula is as follows, but doesn't work? =IF([Size]1 =…
-
Disabling Field Logic?
Hello Community, I am sure this is an easy task but for the life of me l can't make it happen. I setup some field logic to make the user enter a date only after the condition was met, since this is a new process and user is still catching up with entering the data, we decided to disabled this logic so they can just fill…
-
Counting number of new rows using Created (Date) and resetting each week
Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday. I want to: "Look in the Created (Date) column of Sheet 1 and count if the date [that this row was added] is…
-
Pushing data from Smartsheet to 10000ft
Hello, i am trying to set up a project request form which requires authorisation and once this is recieved it pushes fields through to 10000ft as a new project. I can see how to send info through to Slack and MS Teams, but not 10000ft. Can anybody help? Thanks
-
Join Collect Function not working
Hello! I have this formula and it doesn't seem to work: =JOIN(COLLECT([Capacity-Space Planning]2:[Capacity-Space Planning]245, [Property Name]2:[Property Name]245, [Property Name]@row, Space2:Space245, Space@row)) I'm not sure what I'm doing wring, it's not bring back anything. Help!
-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
Hello all, I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({Total}, but when I add the criteria for each department I get # INCORRECT ARGUMENT SET.…
-
My simple NETWORKDAYS is not correct. I'm stumped. :(
Trying to figure out what I'm doing wrong here. I want to calculate the number of work days between two dates. My formula: =NETWORKDAY([Start Date1]5, [End Date1]5) It returns 62, but should be more like 86. What am I doing wrong here?
-
Set a default value in a pick list column
I have a column in a project tracking smartsheet that shows the status of a project. I would like the parent row for the project to automatically change depending on the status of the child rows. I can do that through the formula: =IF((COUNTIF(CHILDREN(), "Withdrawn") + (COUNTIF(CHILDREN(), "Requested"))) =…
-
2 pet peeves - Printing and Filters for columns
Not really a question. More of constructive criticism/asking for better developed features. I use Smartsheet as a scheduling tool at our company, We use master project sheets and a series of project reports and company reports. We generally use Gantt Charts so mostly these comments pertain to that view. For the most part,…
-
Shouldn't Multi-factor be standard?
I just wanted to get a sense from other business customers if they are looking for multi-factor to be a standard feature for all accounts? I'm curious why SmartSheet isn't trying to secure all their customers with common security technology? Thoughts?
