-
Sumif matches criteria from multi select dropdown
Please help, i want to sum the Time Required in case the Week Number column has 1 and update Status is Monthly. I used this below formula but its not working. SUMIFS([Time Required (Hrs.)]2:[Time Required (Hrs.)]6, [Week Number]2:[Week Number]6, HAS([Week Number]2:[Week Number]6, "1"), [Update Status]2:[Update Status]6,…
-
Calendar Week Commencing Date
Hi This may be a User Setting or Project Setting but I cannot find it so any pointers would be appreciated. Our Week Starts on a Monday. How can I have this changed overall? I need this for when individuals upload invoices and I ask them for the Week End and want them to show the Sunday at the end of the week. It seems odd…
-
Using smartsheet individual plan but I'm unable to create an access token. Any add-on or refund?
I upgraded my plan and need to link an API to it but unfortunately Access token isn't available in Individual Plan. Is there an add on for that or can someone please tell me the refund policy since this is really unfortunate for me.
-
Report Sheet Selection by Folder
Is there any method to retain the selection of a Folder under a workspace as the location of all sheets for reports? It checks the sheets and retains those but does not retain the folder and does not add new sheets from the folder. If you move a sheet to a different folder, it retains the sheet.
-
Why can't I add anymore attachments when I have not reached my storage limit
Hello, >Ive tried uploading files big and small but they just keep disappearing! >No error messages >No other account can attach either >It won’t let me attach to any rows >It won’t let me add attachments to any other sheets now either >Also we have 300GB and only used about 2GB, please help!
-
Help with if max collect formula
Hello, Sorry I know there are already questions on this but I'm not getting it. I have a column [Users] of duplicate users, and a second column with unique numbers [Row ID] In a third column I am trying to get "Ignore" or "Select" based on the highest number per user So in the example above the PCUK832 should say ignore…
-
Is there a better way to write a formula that collects data for each week of the year?
Hello This is my current formula. It works but is laborious to write out. Is there a better way? =COUNTIFS({CBTC Feeder File Range 2}, >=DATE(2020, 6, 1), {CBTC Feeder File Range 2}, <=DATE(2020, 6, 7), {CBTC Feeder File Range 1}, FIND("ITAV", @cell) > 0)
-
View Cell History - Forms - Created by: User
Hi, Currently, when submiting a from, it says in cell history "Created by: User" Is there a way to view info. from the one who submitted a form, in the view cell history in smartsheet? Maybe it should say the name, taking it from the name section on the form etc. Thank you!
-
How can i create a master sheet from separate sheets?
i want to create a masters sheet for a general over view of projects in the pipe line Sheet 1. Sales this will have customer info, size of job and a fee key points of the project sheet 2. project management, who is contracted what we need to traack sheet 3 owner billing sheet 4 sub billing master sheet would take job…
-
Form - Branding
Hello, How do I add my logo to the Smartsheet update form? See attached for example.